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?

Your Answer:

Login to answer

Other forums

need to apply an if/else statement to Tim Thumb script
Not sure how to work this. I essentially want to call a variety of image sizes based on which style

asp authentication problem
Hello all, I want to use the asp authentication (from asp.net configuration) in my web site. there

Loop column after 2 results
Hello All.

Here is what I have:

Client ID Company name Clien

Email logic not working
I would like to send an email using the php email() function then if it does execute i.e sends i wou

webpage with (simple) login & mysql-db
Hi all,

What I was looking for before was a multi-user password manager, web-based! The offer

Beginners syntax and loop questions - help please!
Hi everyone,

I have some problems with php code. I'm currently in the middle of learning php,

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

Using CSS to format MySQL query
Hi,

If i want to have a news page on my site, which displays all records of a table in descen

Delete all from a table
I can not get the following code to work. If I run the sql statement in the db it will delete all t

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added