[Resolved] Check to see if it exists?

[Dolemite50]

Hello,
I am trying to find the code to see if a result exists, and to do stuff if it doesnt. In this case I am trying to see if there is an entry for the current $user_id in band_page.

					
$checkbn = "SELECT * from band_page WHERE bandid='$user_id'";
$rs = mysql_query($checkbn, $conn) or die(mysql_error());
 $bandid = mysql_fetch_assoc($rs);
if(mysql_num_rows($bandid)){		

But it gives me this:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/public_html/page.php on line 13

Thanks

[devinemke]

that's becuase $bandid is an array, not a result resource. you need to feed $rs to mysql_num_rows().

[Dolemite50]

I'm very sorry, but that last line lost me. Feed $rs ?

[devinemke]

$checkbn = "SELECT * from band_page WHERE bandid = '$user_id'";
$rs = mysql_query($checkbn, $conn) or die(mysql_error());

if (mysql_num_rows($rs))
{
	$bandid = mysql_fetch_assoc($rs);
	print_r($bandid);
}
else
{
	echo 'nope, no records';
}

[Dolemite50]

Thank you very much!!!!