note 83296 added to faq.databases

It connects to the database ok, and it found the database. When I try and retrieve the information though, it gives me the following errors: Database query failed!!!!: It does not give me a mysql_error() I am running this on Apache 2.2.8, PHP 5.2.6 & MySQL 5.0.45 Here is the code i am using: <?php //3. Performing database query $result = mysql_query("SELECT * FROM subjects" , $connection); if(!$results) { die("Database query failed!!!!: " . mysql_error()); } //4. Use returned data while($row = mysql_fetch_array($result)) { echo $row[1]." ".$row[2]."<br />"; } ?> Can anyone help? ---- Server IP: 209.41.74.194 Probable Submitter: 69.139.158.91 ---- Manual Page -- http://www.php.net/manual/en/faq.databases.php Edit -- https://master.php.net/note/edit/83296 Del: integrated -- https://master.php.net/note/delete/83296/integrated Del: useless -- https://master.php.net/note/delete/83296/useless Del: bad code -- https://master.php.net/note/delete/83296/bad+code Del: spam -- https://master.php.net/note/delete/83296/spam Del: non-english -- https://master.php.net/note/delete/83296/non-english Del: in docs -- https://master.php.net/note/delete/83296/in+docs Del: other reasons-- https://master.php.net/note/delete/83296 Reject -- https://master.php.net/note/reject/83296 Search -- https://master.php.net/manage/user-notes.php