[Resolved] how to check if a value is 0 (zero)

[ceanth]

Im not very good with php but basically i have a customer table and i want to check if a field is empty,

$result = mysql_query("select cust_cc from customer where cust_no = $_SESSION[cust_no]");
if $result = 0
{
echo "credit card not in system";
}

Doesnt seem to work, and the page doesnt load up. Anyone have any suggestions?

[tuf-web_co_uk]

$result = mysql_query("select cust_cc from customer where cust_no = $_SESSION[cust_no]"); 
$num = mysql_num_rows($result);
if ($num == 0)
{ 
echo "credit card not in system"; 
}
else {
// do something els
}

[ceanth]

ah yes, thank you 😉