silly mysql_fetch_related error

[floaty]

Now, I know people have seen this mysql_fetch_array error before. I get this warning every time I have a while loop with a mysql_fetch_array in it.

This code worked on another server, but not on my production server. I have test the mysql query and it works. I has to be some problem with the mysql_fetch_arry function.

Does anyone know of any thing i'm not doing? please help. thanks.

-dan

here is my code:

$db = mysql_connect("localhost", "user", "pass");
mysql_select_db("dbName",$db);
$table = "tableName";

$query = "SELECT * FROM $table;";
$result = mysql_query($query,$db);
while ($myrow = mysql_fetch_array($result))
{
echo $myrow["fieldName"];
echo "<br>\n";
}

[kparker]

Does anyone know of any thing i'm not doing

Not really, but you can PHP/mysql tell you by testing the return
value of your mysql functions, and displaying $php_errormsg if any
of them fail. This should pinpoint exactly what it going wrong.

[Anon]

Well first of all... what exactly is the error? (use mysql_error())

and second... acording to the manual you shouldn't end a mysql_query() using a semicolon.

so
$query = "SELECT FROM $table;";
should be
$query = "SELECT FROM $table";

dunno if this helps... i can't really see what wrong if you don't give the error it reports (btw, did you try running the query from a console?)

[dcotter]

You don't need the ";" inside the query variable...the only reason I can think you might be getting an error is that there are no rows in the table. I seem to remember getting errors from queries when trying to loop using mysql_fetch_array() when there are no rows returned. Use simple error handling to test this:

if (mysql_num_rows($result) > 0) {
// your code here
} else {
// print error
}