PhotoPost Community - View Single Post

cwbullet · July 5th, 2004, 11:59 AM

I just installed review post and in the admin panel when I hit product order, I get this error:

MySQL error reported!

Script: adm-order

Query: SELECT id,user,userid,cat,title,bigimage,disporder FROM rp_products WHERE cat= AND disporder < 99999 ORDER BY disporder,lastpost DESC

Result: 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 disporder < 99999 ORDER BY disporder,lastpost DESC' at line

Database handle: Resource id #6

July 5th, 2004, 11:59 AM	#1 (permalink)
cwbullet Junior Member Verified Customer Join Date: Apr 2002 Posts: 8	Error in Product order I just installed review post and in the admin panel when I hit product order, I get this error: MySQL error reported! Script: adm-order Query: SELECT id,user,userid,cat,title,bigimage,disporder FROM rp_products WHERE cat= AND disporder < 99999 ORDER BY disporder,lastpost DESC Result: 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 disporder < 99999 ORDER BY disporder,lastpost DESC' at line Database handle: Resource id #6