no results

[rocket]

ok here it is. i am sending quary to my data base amd when it finds a match it works fin but when it does not it does not return anything . i wnat it to return a message 'that says it did not find any thing does any one know a fuction in mysql or something else that could do this

[sid]

<?PHP

$result = mysql_query("SELECT prices
    FROM menu
    WHERE sid IN ('nightclub')");
if (mysql_num_rows($result)) {
    //handle data
}
else {
    print "no results you little lulu!";
}
?>

[rocket]

thank you but is there another way to do it

[rocket]

i thought there was a fuction that could do it but i cant find it