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

[workaholic]

Help Help Help, I am doing a website and this is the error i keep getting, not on all sql queries just on those i used "while" with here is the query:

include("db_info.php");
$query = mysql_query("SELECT * FROM abouthedgelinks");

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

echo "<tr><td align=\"left\">";
echo "<a href=\"abouthedge.php?id=".$result['id']."\" class=\"text10\">".$result['name']."</a>";
echo "</td></tr>";

}

NOTE: from time to time when i click the refresh button it works fine then when i click on one of the results it goes back to the same error., I did an echo on the query and it worked fine, I tried to use that query on phpmyadmin and it gave me the right results, i dont know what to do anymore, tried mysql_fetch_assoc and still got the same results.

Please help.

I double checked the spelling of the table or the case its all correct.

Thanks in advanced.

[laserlight]

Generally, that warning is caused by one or more of these:

1. Failed to connect to the database server.
2. Failed to select the database.
3. Failed SQL statement.

If the table name is correct, then #3 can be ruled out since the SQL syntax is correct. Your test with phpmyadmin confirms this.

[workaholic]

Thanks for the quick reply,

I figured it out.. my database was not selected.

Thanks

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.