query based on last 24 hours

[Rollo_Tamasi]

i have tried googling for the syntax to run a query that can count the amount of new entries into a database based on todays date.

I have a field in my database called sign_up_date which is of type datetime and has a default of 00-00-0000 00:00:00

$query = "SELECT COUNT(id) FROM users WHERE signup_date=........... ?

can anyone help me out with the code required?

[Houdini]

You would maybe want to use MySQL Date and time functions;

SELECT something FROM tbl_name
WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY)

See Date and Time Functions

[Rollo_Tamasi]

cheers mate, you put me on the right track

$query = "SELECT COUNT(userid) FROM users WHERE signup_date < date_format(date_add(CURRENT_TIMESTAMP(), interval 1 day),'%Y%m%d000000')";