i am using this on log-in but cant get it to work for logout so it sets the value back to '0'
Any ideas


$sql = mysql_query("UPDATE users SET online='1' WHERE username='$username' AND password='$password'");

UPDATE `users` and not just UPDATE users because users is a keyword in MySQL and here in your case its the name of a table. For that you need to pu it in ``. Infact its good practice to place all your tablenames within ``.

Note: ` is not '. ` is on key left of 1.