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, 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'
Last edited by Tom1234; July 25th, 2004 at 11:56 AM.