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
