you should use mysql_num_rows() to check for records returned instead of 
using mysql_query().

this is because if $query is a valid $sql statement, mysql_query() will 
always return a resource link. which evaluates to true.

so this will work for you:

if (mysql_num_rows($result))
   echo "record found";
else
   echo "record not found";


--lance

Monty wrote:
> Even though I have no record in my MySQL DB with that has "005" in the ID
> field, the following statement always reverts to Record Found, or True, no
> matter what ID I use. What's wrong? I'm using PHP 4.2.2. Has something
> changed that makes this work differently? Thanks.
> 
> --------
> 
> $query = "SELECT id FROM member WHERE id = 005";
> $connect = mysql_pconnect("localhost", "dbname", "password");
> $result = mysql_query( $query, $connect );  // Query DB.
>             
> if ( !empty($result) ) {
>     echo "RECORD FOUND";
> } else {
>     echo "RECORD NOT FOUND";
> }
> 
> 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to