Hello I'm having a problem with a query. I get the following error/warning:
PHP Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/mlhwebus/public_html/fairyfaun/sql/admin/send.php on line 385
Usually when this happens I have the program echo the query and then try it with PHPMyAdmin which will flag something wrong with the sql and I can get it fixed.
Today, however, I did the same thing and the query which follows in the () works fine in PHPMyAdmin.
(SELECT ltrque.id, dealer.email from ltrque, dealer where ltrque.dealid = dealer.id and ltrque.sendmeth = 'e' and ltrque.ltrsent = 'n' and ltrque.ltrtype = '2')
anyone have any ideas why php is flagging it as not a valid MySQL result?