|
|
Posted by Dave Nash on 01/12/07 02:12
You had given me some help with the following code:
select i.itemid, i.itemname, i.attachment, i.price, i.itemcode
from items i join ItemCat ic on i.itemid = ic.itemid where ic.catid =
$catid
But when ive gone from my local server to live I come up with the
following error
#1064 - You have an error in your SQL syntax near 'on i . itemid = ic
.. itemid where ic . catid = '40' LIMIT 0, 30 ' at line 1
PHP + mysql version are different.
Any Ideas???
Navigation:
[Reply to this message]
|