Posted by Chris Shiflett on 10/21/55 11:14

Mark Sargent wrote:
> *Warning*: mysql_fetch_row(): supplied argument is not a valid MySQL
> result resource in */var/www/html/phpmysqltable.php* on line *36*
> Below are snippets of my code,
>
> Line 22: $result = mysql_query("SELECT product_name,
> product_model_number, product_serial_number FROM Products",$db);
> Line 36: while ($myrow = mysql_fetch_row($result)) {

mysql_query() returns false on failure, and false isn't a valid MySQL
result resource. A quick and dirty way to alert yourself to the problem
is to change line 22 to this:

$result = mysql_query('SELECT product_name, product_model_number,
product_serial_number FROM Products', $db) or exit(mysql_error());

Hope that helps.

Chris

--
Chris Shiflett
Brain Bulb, The PHP Consultancy
http://brainbulb.com/

• Next in forum: RE: [PHP] Any clever ideas on how to find some random records?
• Prev in forum: Re: [PHP] Re: problem with array diff, need to reindex array according to key
• Thread view: Re: [PHP] Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource

[Reply to this message]