Logged in users

[vividona]

I need to select users who logged in during 24 hours

$time = time() - (60*60*24);

	$chkusers = $SiteDatabase->dbqueries("SELECT `uid`, `username`, `lastaccess` FROM
	" . ArticleSystem::BHL_DB_PREFIX . "" . ArticleSystem::BHL_DB_USER_TBL . " WHERE `lastaccess` < '$time' ORDER BY `lastaccess` DESC");

 

my code count wrong time.

 

[Adam]

What data type is the "lastaccess" field?

[vividona]

I inserted into it php time() function

like this 1268019084

[vividona]

It is working now according to my code

but it select users after 24 hours

I need during 24 hours not after

[trq]

Again....

 

What data type is the "lastaccess" field?

[vividona]

varchar

[trq]

So, how do you expect a database to sort a string based on time? lastaccess needs to be a timestamp.

[vividona]

I resolved it like this

$time = time();
	$time2 = time() - (60*60*24);

	$CheckArtisList = $SiteDatabase->dbqueries("SELECT `uid`, `username`, `lastaccess` FROM
	" . ArticleSystem::BHL_DB_PREFIX . "" . ArticleSystem::BHL_DB_USER_TBL . " WHERE `lastaccess` > '$time2' AND `lastaccess` < '$time' ORDER BY `lastaccess` DESC");

 

thank you guys