1
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