PhotoPost Community - View Single Post

Tom1234 · July 25th, 2004, 11:37 AM

Can I get some help with this error? RP 2.8d.

An error was encountered during execution of the query:

SELECT id,user,userid,cat,title,manu,bigimage,views, id*0+RAND() as rand_col FROM rp_products WHERE bigimage !='' AND approved='1' AND cat in (myprod,1,23,35) ORDER BY rand_col DESC

The query returned with an errorcode of:

Unknown column 'myprod' in 'where clause'

July 25th, 2004, 11:37 AM	#1 (permalink)
Tom1234 Member Verified Customer Join Date: Sep 2003 Posts: 106	Unknown column 'myprod' Can I get some help with this error? RP 2.8d. An error was encountered during execution of the query: SELECT id,user,userid,cat,title,manu,bigimage,views, id0+RAND() as rand_col FROM rp_products WHERE bigimage !='' AND approved='1' AND cat in (myprod,1,23,35) ORDER BY rand_col DESC The query returned with an errorcode of: Unknown column 'myprod' in 'where clause' Last edited by Tom1234; July 25th, 2004 at 11:56 AM.*