if record not found display message

[jesushax]

hello again

 

$sql = mysql_query("SELECT * FROM tblUsers WHERE UserEmail='".$Email."' ") or die(mysql_error());

$rspass = mysql_fetch_array($sql);

 

i want to do write a the message email address does not exist if the query doesnt return any results

 

any hints?

 

cheers

[bpops]

<?php

 

if(!mysql_num_rows($sql)){

// No results exist

echo 'Email address does not exist.';

}

 

?>

[cooldude832]

<?php

 

if(!mysql_num_rows($sql)){

// No results exist

echo 'Email address does not exist.';

}

 

?>

 

Not exactly a perfect solution as mysql_num_rows could fail in other ways

better is

<?php
if(mysql_num_rows($sql) < 1){
#Not found
}
else{
#there is at least 1 record
}
?>

 

the function itself could fali and !mysql_num_rows($sql) on a function failure is also true even though it isn't really