[Resolved] Please help with PHP/MySQL error

[brailleschool]

I am not sure what is going on here, please advise.

error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/paddy/public_html/newadmin/resourcescenter/delete/BrailleBooks_Delete.php on line 8

line 8 being:

while ($rows = mysql_fetch_array($result))

<?php
include("../../../config.php");
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "SELECT * FROM braillebooks order by id asc";
$result = mysql_query($query, $connection);
echo "<table width=\"100%\" border=\"1\">";
echo "<tr><td><b>ID</b></td><td><b>Company</b></td><td><b>City</b></td><td><b>State</b></td><td><b>Zip</b></td><td><b>Delete?</b></td></tr>";
while ($rows = mysql_fetch_array($result))
{
echo "<tr><td>$rows[id]</td><td>$rows[company]</td><td>$rows[city]</td><td>$rows[state]</td><td>$rows[zip]</td><td><a href=\"BrailleBooks_Del.php?id=$rows[id]\">Delete</a></td></tr>";
}
echo "</table>"; 
?>

[chyan]

i suggest you to check your connection, it might be your connection
had not been made, thats why you receive error massage when you try to fetch
data from mysql throught mysql_fetch_array

in your current error script, try to echo your connection variable
like $server, $db_user , $db_pass and $database to know whether the variable
contain a value or not

[brailleschool]

I found the problem, I was accessing the wrong database. DOH!