Wierd mysql_fetch_array problem

[Anon]

I don't really know what is wrong with this but here's the code:
$result = mysql_query("SELECT * FROM pet");
while ($r = mysql_fetch_array($result))
{
$lf = $r["num"];
$lu = $r["sec"];
$id = $r["id"];
$name = $r["name"];
}
It gives me the error:
Warning this is not a valid mysql resource
Or something like that
And every time I refresh, I goes through the loop once more without an error.
By the way: I'm using apache on localhost
Thank you,
EJ

[kparker]

I don't really know what is wrong

What's wrong is on two levels. The first problem is, you're not checking the return value of mysql_query() to see if it failed or not. In your case, it is failing, so when you try to use $result it doesn't represent a valid result set.

Do this:

if (! ($result = mysql_query(...)))
  echo "Query error: " . mysql_error();
else
  {
  $r = mysql_fetch_array($result))
    ...
  }

This doesn't solve the ultimate cause of the problem, but it will let you see exactly what mysql doesn't like about your query.

[Anon]

Sorry, I accidentally used another query variable inside the loop too. I used $query again. I changed it and it was gone.
Thanks for trying, EJ