PhotoPost Community - View Single Post

Scott · September 27th, 2009, 06:32 AM

Ok, I'm installed, now seeing this error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/datingsi/public_html/reviewpost/showcat.php on line 577

Debug email message:

An error was encountered during execution of the query:

SELECT id,user,userid,cat,date,title,description,keywords,bigimage,views,approved,rating,manu,numreviews,extra1,extra2,extra3,extra4,extra5,extra6,disporder,zipcode FROM rp_products WHERE approved=1 AND cat=2 ORDER BY disporder,price DESC

The query returned with an errorcode of:

Unknown column 'price' in 'order clause'

September 27th, 2009, 06:32 AM	#6 (permalink)
Scott Member Verified Customer Join Date: Dec 2008 Location: Centreville MD Posts: 45	Ok, I'm installed, now seeing this error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/datingsi/public_html/reviewpost/showcat.php on line 577 Debug email message: An error was encountered during execution of the query: SELECT id,user,userid,cat,date,title,description,keywords,bigimage,views,approved,rating,manu,numreviews,extra1,extra2,extra3,extra4,extra5,extra6,disporder,zipcode FROM rp_products WHERE approved=1 AND cat=2 ORDER BY disporder,price DESC The query returned with an errorcode of: Unknown column 'price' in 'order clause' Last edited by Scott; September 27th, 2009 at 06:47 AM.