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

[dlc2000]

hi,

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/only4you/public_html/asset/include/destra.php on line 10

I use it so:

$sql = "SELECT * FROM people order by peo_nome";

$result = mysql_query($sql);

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

echo "<font class=verdana10neroB>$myrow[peo_nome]</font><br>$myrow[peo_testo]<p align=justify>";

}

What's wrong?

regards

[khaine]

The error might not be the fault of the actual query. It could be caused by the login or the database select or anyhting else that happened earlier in the script. try either adding some error checking to the script ie check that the connection you made is actually made or post the entire script here so it would be easier to spot the problem

Mark.