Thread: SQL error
View Single Post
Old May 1st, 2009, 03:48 AM   #1 (permalink)
drare
Member
Verified Customer
 
Join Date: Feb 2009
Location: Holland
Posts: 116
SQL error

Today I got a lot of SQL errors and I don't know what it means and what to do, should I ignore these? Are they essential? Please advise.

An error was encountered during execution of the query:

SELECT p.id,p.title,p.userid,p.cat,p.approved,p.storecat,p.bigimage FROM pp_photos p LEFT JOIN pp_categories c ON p.cat=c.id WHERE p.userid= AND c.password='' ORDER BY p.date DESC LIMIT 5

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.password='' ORDER BY p.date DESC LIMIT 5' at line 1
drare is offline   Reply With Quote