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 Member Posts: 10
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?

Comments

  • Andre YoungAndre Young USAMember Posts: 0

    ______ ( http://forcoder.org ) free ebooks and video tutorials about \ Objective-C, R, C#, MATLAB, Swift, Delphi, Go, Java, Visual Basic, Assembly, C, PHP, Ruby, JavaScript, C++, Python, PL/SQL, Scratch, Visual Basic .NET, Perl Transact-SQL, FoxPro, Logo, Dart, Bash, LabVIEW, Awk, Hack, Kotlin, Apex, Rust, Lisp, F#, Ada, SAS, Fortran, Scheme, COBOL, ML, Julia, Clojure, VBScript, Alice, Lua, Crystal, Erlang, Scala, ABAP, D, Prolog \ ______

Sign In or Register to comment.