1146 Error : Query Category table

[rej2k7]

Hi,

I am in need of creating a slide, where i have to query table (categories), i got it working excellent on local host, zc, but when i check with server i got mysql error no : 1146

Its running with 5.0 mysql db.
I dont know what went wrong, please help.


Thanks
Reji.

[Absolute]

Error 1146 is "Table Name Doesn't Exist". Did you use the TABLE_CATEGORIES constant to call the name of your table, or did you just put "categories" in the SQL? You MUST use the TABLE_xxxxx constants when writing SQL statements, as they take into consideration any table name prefixes.

So your SQL should look like:

$categories_rs = $db->Execute("SELECT c.categories_id, cd.categories_name FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd WHERE c.categories_id = cd.categories_id AND cd.languages_id = '".(int)$_SESSION['languages_id']."'");

.... or similar.

Absolute

[rej2k7]

Thanks a lot ..