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