whos online~?

[dvwhi]

ok i have a mysql table with all my users but on my site i want it to once you login a the number 1 comes under the coloum "online" on my database and on the site i want it to show all the ones with the number 1 under the coloum "online" in my database

eg >

There are currently 0 users and 0 guests online.

[dvwhi]

i want to change my question abit i want it to display how many people have the number one in the coloum online i have done the coding for it to update the user in the table here is the code!

$sql='UPDATE users SET `online` = "1" WHERE `Username` = "' . mysql_real_escape_string ( $_POST['username'] ) . '" AND `Password` = "' . mysql_real_escape_string ( md5($_POST['password'] ) ) . '"';
if (!mysql_query($sql))
  {
  die('Error: ' . mysql_error());
  }

[Weedpacket]

Sounds like you need to read up on how to use the SELECT statement.