How many users online in the last 24-hours using time()?


Posted on 16th Feb 2014 07:03 pm by admin

I'm fairly new to PHP. I have a MySQL table called 'users' and a field called 'loggedin' which is in time() format.

I need a query that'll check how many players have logged in within the last 24-hours, but I'm not sure where to start. I already have the database connection setup, and just need the amount to be set to "$online24h"

Can anyone help me please?

No comments posted yet

Your Answer:

Login to answer
253 Like 25 Dislike
Previous forums Next forums
Other forums

Update data to upper case in parent/child tables
Hi Gurus!

In production we have a product table and which is being reference by many tabl

bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error

Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any do

Parse multirow HTML table
Hello all,
I have a site I am working on. Its a sports site and I am trying to add stats to a DB

php form help
Hey,

I use a control file to set my meta tags and titles

Here's an example
Code: &a

Undefined offset
The following script checks to see if the user answer matches the correct answer.

Form Fiel

insert mysql embeded videos as blobs?
Using TinyMCE my client will be able to embed images and flash videos into large columns of text whi

Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo

Need help: how to catch acess of undefined class properties
Hello. I am learning OO with PHP and have hit a problem.
Some code runs as perfectly valid code,

how to load a Sys file with system load and call images?
normally you need register the module as a service with CreateService, and start the service

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash