Stuck on SQL Statement

[Kev0121]

Well in my database in my users table i have a field called 'active' and when users are logged in it changes to 1. What im trying to do is write a sql statement that says check if the user id of $_SESSION['uid'] if their active field is set to 1, if so echo out "Online" if that makes sense? sorry lol didnt know how to describe.

 

something like this...

$sql = "SELECT active FROM users WHERE active = 1 AND  id = ' " . $_SESSION['uid'] . " ' ";

 

Thanks

 

/Kev

[Michdd]

$sql = "SELECT active FROM users WHERE active = 1 AND  id = '{$_SESSION['uid']}' ";

 

I think the query you were trying to write is something like that? Although, I don't see why you'd only want to select active..

[Nazirul]

lol .. do u mean when a user log in, then the script will UPDATE the SQL in the column 'active'

 

u can do such :

 

once the correct id and password;

 

if (mysql_num_rows($result) == 1)

{

//sql UPDATE here