[Resolved] If !results then...

[szym9341]

I have a simple query and for some reason I can't get this bit of code to work.. any ideas?? The !$results never rings true.. I have deleted all entries in the datbase... the database query says zero rows... please help....

$result = @mysql_query("SELECT * FROM vendors ORDER BY vendor_name ASC");
if (!$result) {
   echo( "<p>You DO NOT have any results</p>" );
   exit();
}

echo "<p>You have results</p>";

[szym9341]

I didn't execute the variable... ugg.. sorry to bother you people.

[azunoman]

I am also new to this and have the following function that helps me with errors: (which displays mysql errors)

function showerror(  )  

{     

     if (mysql_error(  ))
        die("Error " . mysql_errno() . " : " . mysql_error(  ));
     else]
        die("Could not connect to the DBMS");
}

I can usually figure out what is wrong after seeing the error message. However....1064 messages are vague in that it tells you 'near' where the error is...lol...if it finds and error then one would suspect that it would now 'exacatly' where the error is.

		
$result = @mysql_query ($query) or die (showerror());
if ($result) {   		
echo '<h3>Your request was completed</h3>';  		
} else { 
// If it did not run OK.  		
echo '<p>Request failed</p>';