Last logged in user

sissy

Hi folks,

Just a small problem, i am trying to get the last logged in user but its just quite not working right.

if ($scount == 'last') {
    // less 30secs so it doesnt grab the user logging in
    $ndate = date('Y-m-d H:i:s', time() - 30);
    $query = $db->query("SELECT username FROM login WHERE last < '$ndate'");
    $row = $db->fetch_array($query);
    echo $row['username'];
}

This is always grabbing the first user in the table and am puzzled a bit how to achieve this.

thanks.

ElectusUnum

First of all, wouldn't < than $ndate mean it grabs all the users with a date before your $ndate ?

Secondly,
Y-m-d H:i:s isn't the format MySQL stores a timestamp, its mashed together Ymdhis or something similar. Sorry if this is a totally n00b comment, my brains been scattered lately 😉

sissy

Originally posted by ElectusUnum
First of all, wouldn't < than $ndate mean it grabs all the users with a date before your $ndate ?

Yes this is true thats why i asked the question couldnt work it out, and now its sorted.

Originally posted by ElectusUnum
Secondly,
Y-m-d H:i:s isn't the format MySQL stores a timestamp, its mashed together Ymdhis or something similar. Sorry if this is a totally n00b comment, my brains been scattered lately 😉

Not true as i am using the DATETIME field in the DB and the format is 0000-00-00 00:00:00 and using the NOW() function of mysql to insert the date and time.

http://www.mysql.com/doc/en/DATETIME.html

Anyway all working now, thanks anyway.