PHP: Is my method alright?

egon1k

New Member
I'm making a "newest users" page.All users have an timestamp in the column "unixdate", that it stores when you register. Dont know if this is smart, but I like how effective the UNIX time() is and how simple it is.Now I am showing the newest users within 24 hours by doing this:\[code\]$long = "86400"; // 24 hours in seconds$query = "SELECT * FROM users WHERE unixdate > time()-$long ORDER BY unixdate DESC";\[/code\]Is this an good method to show on? And if I would like to show newest within 3 days, would it be * 3?Thank you
 
Back
Top