[umarrana]

Hi dear
this is the a big problem always come in my code
why this is with me
my script was running fine but shutdown my computer and start again this error come

i try to do every thing i past the backup but nothing its still same what is this problem can anybody now about this

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\a\login.php on line 19

this is error come in main site

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\a\display.php on line 133

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\a\display.php on line 6

Here is my code
Line No 6
while ($row=mysql_fetch_array($result)) {

Line No 133

mysql_free_result($result);

[Nico]

The error happens actually before, when you run a mysql_query() statement.

Add a OR die(mysql_error());, at the end of mysql_query(), to get the exact error from MySQL. It's impossible to help without seeing the error, or at least the query that caused the error.

[Anoop]

in your code
check first if(isset($result ))

[End User]

Originally Posted by umarrana

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\a\login.php on line 19

In plain English this usually means you aren't getting any results back from your query. In this case I'd guess it's because you aren't getting a valid connection to the database but it's impossible to say based on the error message alone.

[mab]

Anoop, a mysql_query() function call that fails will return a FALSE value. A query that executed with no errors, even if it is an empty result set with zero rows, will return a result resource. An isset() test of either of these possible values returned by a mysql_query() will always be true.

[Anoop]

please send the full code ...
that is $result="" ?


while ($row=mysql_fetch_array($result)) {