[Marshal Halloway]

Several syntax errors came in today.

SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views FROM cp_products p
LEFT JOIN cp_favorites f ON (f.product=p.id)
WHERE p.approved=1 AND f.userid=

ORDER BY date DESC
LIMIT 30

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 'ORDER BY date DESC
LIMIT 30' at line 5

SELECT msgid,datestamp,message,type,product FROM cp_messages WHERE userid= AND status=0 ORDER BY datestamp DESC LIMIT 15

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 status=0 ORDER BY datestamp DESC LIMIT 15' at line 1

SELECT userid,username,title,signature,avatar,usergroupid,homepage,icq,aim,yahoo,joindate,posts,birthday,location,interests,occupation,bio,offset FROM cp_users WHERE userid= LIMIT 1

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 'LIMIT 1' at line 1