Returning a 0 or 1 from a query

[newphpbie]

Hi all,

I am trying to return a value of either 1 or 0 depending on if the record exsists or not.

The user will type in a password.. $pass

I want to check for a record of this password in a db...

$query="SELECT userID FROM users WHERE userPass="'.$pass.'"  ";

I need the code to return a value of 0 if the record doesn't exsist, or a 1 if it does....or something similar to that.

Can anyone help please...

 

[hos2]

$query="SELECT userID FROM users WHERE userPass="'.$pass.'"  ";
$rs=mysql_query($query,$conn);
$aantal=mysql_num_rows($rs);

if ($aantal==1) {succeeded} else {wrong}

 

[newphpbie]

Worked around it, but I'll give what you say a try.

Thanks.