How do I get rows for last 24 hours by unixstamp

[khucdieulinh]

I have this;\[code\]$long = "86400";$query = "SELECT * FROM users WHERE unixdate = UNIX_TIMESTAMP()-$long ORDER BY unixdate DESC";\[/code\]But it doesn't work. I would like to show all new users within 24 hours