Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Need help with vbulletin, selecting by the day

KrelianKrelian Posts: 10Member
What I want to do, is select the users that have been online starting from midnight. Like a list of users online today. Anyway, here is the current code that I have:
[code]
$loggedins=$DB_site->query("SELECT * FROM user WHERE userid > 0 [b][/b] ORDER BY invisible ASC, username ASC");

[/code]
I want to select user by:
$currentday = vbdate($dateformat,time());
$lastloggedin = vbdate($dateformat,lastaction);
With the difference between the two = 0. How do I put this in the above code? I have tried (vbdate($dateformat,lastaction))=(vbdate($dateformat,time())) and it didn't work. Any other ideas?
Sign In or Register to comment.