XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk




1
AliJay
C-Jay content 3

  • 2004/5/4 15:44

  • AliJay

  • Just popping in

  • Posts: 5

  • Since: 2004/3/31


I have designed and tested my games database using php it works out side of the XOOPS but i want ti to look like everything else. I can get most of it to work apart from one thing when i select from a database there is a problem when selecting records when their category is like a variable here is the code.

$query = "SELECT `ID` , `Name`  , `Category`  
FROM `xoops_game_db`
where `Category` LIKE $rview ";


$rview is a letter and not a number, the problem is it either selects everything when i put '$rview' or nothing when i leave it at $rview.I do get the same problem with numbers

Please could somebody help
Alastair Jay
Topic | Forum


2
AliJay
Re: Games Databse

  • 2004/4/26 15:27

  • AliJay

  • Just popping in

  • Posts: 5

  • Since: 2004/3/31


Ok i have that but what i want is a game database that is just a really long list of games when you open up a game you have a brief amount of information like release dated, developer, publisher, brief description of game and box-art then underneath it searches through news(looking for the keywords gametitle), the reviews section and puts them underneath so that people can see news and reviews etc

or failing this how do i put html functionality into this module here
Topic | Forum


3
AliJay
Games Databse

  • 2004/4/26 14:54

  • AliJay

  • Just popping in

  • Posts: 5

  • Since: 2004/3/31


I would like a module that stores some information about a game but it also searches through the news section and my reviews section for articles about the game and displays them at the bottom.

Could anybody either help me make one(teach me)? or just make one? please
Topic | Forum


4
AliJay
Re: i need help with some code

  • 2004/4/17 19:02

  • AliJay

  • Just popping in

  • Posts: 5

  • Since: 2004/3/31


nevermind i was selecting some of the wrong fields
Topic | Forum


5
AliJay
i need help with some code

  • 2004/4/17 18:53

  • AliJay

  • Just popping in

  • Posts: 5

  • Since: 2004/3/31


Apart from poor presentation and lack of liscences etc what is up with this code?
<?php
require('header.php');


// We must always set our main template before including the header
$xoopsOption['template_main'] = 'db_main.html';

// Include the page header
require(XOOPS_ROOT_PATH.'/header.php');



$sql = ("SELECT * FROM " . $xoopsDB->prefix("games_main") );
    $result=$xoopsDB->query($sql);
    while($myrow = $xoopsDB->fetchArray($result)) {
        
        $xoopsTpl->assign('title', $myrow['game_title']);
        $xoopsTpl->assign('id', $myrow['id']);
        
                          
        
    }    
// Include the page footer
require(XOOPS_ROOT_PATH.'/footer.php');
?>
Topic | Forum



TopTop



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

252 user(s) are online (174 user(s) are browsing Support Forums)

Members: 0

Guests: 252

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits