php error . almost done with this fix!

veranopage

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resourc

The line that this is referring to is....

while($r=mysql_fetch_array($result))

dalecosp

Your query returned no results, or there was a database error, only your script didn't check for that and instead sent the nonexistent resource value to the mysql_fetch_array() function, which then complained it couldn't run ....

veranopage

what more information can i provide to research this further.

veranopage

How do I view my query?

bradgrafelman

dalecosp;10968900 wrote:
Your query returned no results

This will never cause the result of [man]mysql_query/man to be a boolean value - it will simply return a resource to an empty result set (which isn't an error condition).

veranopage wrote:
what more information can i provide to research this further.

If [man]mysql_query/man returns false, try outputting the value of [man]mysql_error/man for debugging purposes.

veranopage wrote:
How do I view my query?

Store it in a variable and simply echo/print that variable.

The common way to debug errant SQL queries is:

$query = "SELECT foo FROM bar ...";
$exec = mysql_query($query) or die("MySQL Error: " . mysql_error() . "\n\nQuery: $query");

That will give you both a) the error message returned by MySQL, and b) the query sent (so you can visually inspect it).