[SOLVED] Query checking

[SirChick]

How do i do a if statement after a query to do something like "if the row does exist.. set value = 1 else set to = 0"

 

This is my query so far:

 

$Check = mysql_query("SELECT * FROM Banks WHERE UserID='{$_SESSION['Current_User']}' AND BankID='1'");

 

 

Any ideas?

[trq]

<?php

  if ($Check = mysql_query("SELECT * FROM Banks WHERE UserID='{$_SESSION['Current_User']}' AND BankID='1'")) {
    if (mysql_num_rows($Check)) {
      // row exists
    } else {
      // row does not exist.
    }
  }

?>

[SirChick]

thanks