[Resolved] Date / Time Sorting

[BulldogGC]

Hey guys,

1. How do I choose all the items of the PREVIOUS day? Today's date is 05/02/03 ... So I want to choose the 1st. I was thinking of just subtracting one day ... but that won't work if it's the 1st and should be going to the 31st ...

2. How would I sort items by time? ORDER BY timeposted DESC ... But with the lack of date sorting pre-built in PHP I fear that might not work. Any suggestions?

Thanks everyone!

[Weedpacket]

$yesterday = [man]date[/man]('Y m d', [man]strtotime/man);
echo $yesterday;

Adjust the date format to whatever is appropriate for your db, insert it in your query à la "WHERE timeposted='$yesterday'", and away you go.

[BulldogGC]

Hmm, thanks for the suggestion but no dice.
Simply putting "yesterday" in doesn't work.

I ended up coding it myself and did so this way --

$currenttime = date('h'); 
$currentdate_queued = date('m/d/y',mktime($currenttime-24));

If anyone knows of a better way out there feel free to let me know.