mysql_query

[slava_php]

when i use select mysql statement i cannot use $result to test if selection occurred. it always returns true. ex:
$result = mysql_query("select * from ... where id = 'name'");
if($result)
{
echo "record exists";
}else{
echo "record does not exist";
}

if i use insert mysql statement, then it works. why?

i'm using: mysql_num_rows($result) with select statements and ex. above for insert statements.

thanks
steve

[cgraz]

Couldn't you do something like

$result = mysql_query("select * from ... where id = 'name'"); 
$num_rows=mysql_num_rows($result);

if ($num_rows >= '1') {
     echo "record exists"; 
} else {
     echo "record does not exist";
}

Cgraz