stuck with query

[talkster5]

Hi there
Always get stuck with simple things when i want to try something new. What i have is the user privalleges saved in a MySQL database as 1 for allowed and 0 for not allowed. What i want to do now is find out whether the logged in user is authorized to have the privallage open to him by retrieving the number from the database.

I have got this so far

<?php
session_start();
$user = $_SESSION['username'];

mysql_select_db($database_Site_Database, $Site_Database);
$sql = "SELECT support FROM client_login WHERE username=$user";
$result = mysql_query($sql) or die(mysql_error());  

}
?>

So then i was thinking something like

if($result == 1) {
  //do whatever

But of course this does not work. So please can you tell me what the if statment or whatever would be to find out whether the number in the column support for the user is a 1 or a 0?

[LordShryku]

See comments...

# Is username an integer? Probably not, so you'll need single quotes...
$sql = "SELECT support 
          FROM client_login 
         WHERE username = '".$user."'";
$result = mysql_query($sql) or die(mysql_error()); 
# Now check and fetch the results
if(mysql_num_rows($result) > 0) {
   #we have a result, go fetch it
   $row = mysql_fetch_array($result);
   # Now the conditional
   if($row['support'] == 1) {
      # do something
   }
}
else {
   # default error message when no rows are returned
   echo 'Invalid username';
}

[talkster5]

Thanks works great.