Is your database configuration the same on both environments? Usually this error comes querying for the wrong table/column name. I have also seen this error when, for example, customer_id = NULL, and in my script I say WHERE customer_id = $customer_id.
---> Jonathan -----Original Message----- From: Salada, Duncan [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 3:00 PM To: 'databarn'; MySQL Subject: RE: Warning suppression? This warning is being generated by PHP not by MySQL. Take a look at http://www.php.net/manual/en/faq.databases.php#faq.databases.mysqlresour ce If you haven't changed anything in your code, you might be using a function in your query that was made obsolete in the new version of MySQL. Check your query syntax because something is definitely wrong and you probably _don't_ want to suppress it. Duncan ----------------------------------------------- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -----Original Message----- From: databarn [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 2:55 PM To: MySQL Subject: Warning suppression? Folk, I'm not having a lot of success with my provider, so I'll ask here. Is there any way to turn _show warnings_ off from script? I cant seem to find anything relevant. I'm getting a warning that, "Supplied argument is not a valid MySQL result resource . . .". I don't see any way to test for this. Have I overlooked something? Or can I disable the warnings from PHP? Or am I just stuck with this? Make a good day . . . . . . barn ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "If you can't beat them, arrange to have them beaten." -George Carlin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
