[SOLVED] Mysql query

[marklarah]

my sql query is failing

        $_SESSION['user'] = $username;


$userr = mysql_query("SELECT * FROM users WHERE username = '$username'");
  $row = mysql_fetch_assoc($userr);
        $_SESSION['lvl'] = intval($row['level']);
$_SESSION['userID'] = intval($row['ID']);



$id = $_SESSION['userID'];


$lin = "UPDATE boards SET llin = NOW() WHERE ID = '$id' ";
mysql_query($lin) or die('Error, query failed');
$liyn = "UPDATE boards SET active = '1' WHERE ID = '$id' ";
mysql_query($liyn) or die('Error, query failed');

 

 

Im getting the Error, query failed, but it still logs the user in, (sets the session which is in the code above), but i it doesn't update the time or the active. Why?

 

 

[Dane]

try

 

WHERE userID = '$id'

[marklarah]

my table ID field is called ID that would not help 

[marklarah]

I had the query on my boards table, not on my users table...