sort by date...

Anon

i am looking for a method to find the last modified date of a directory. however, it seems that the filemtime etc functions only work on, um, files. so i wrote a function to recurse through the directory contents, adding all the filedates into an array. then, i thought, all i need to do is sort the date array and take the most recent date.

BUT - how do you sort by date? i can't believe there isn't a built in method for this in php - but i can't find it! a normal sort orders alphanumerically, while a natural sort orders... well, not in date order.

anyone got the solution to this rather simple problem?

please help - this is really starting to bug me now! many thanks in advance for any offers of support...

Anon

I think I have the sollution...@ least I think I do.

When you make a database you have to add a new colum in the table with "date" on it.
When people fill in something to the database you also take the newest date with
$date = gmdate("Y-m-d");
and you add this value to the row.

Then when you retrieve the values from the database again with PHP and a mysql_query you do this:

$sql = "SELECT * FROM table_? WHERE id>0 SORT BY date";
$result = mysql_query($sql);

and it will sort the arrays/objects by date.
off course you want them in to ways so you can always add "SORT BY date DESC"
DESC = descending (opposite order)...

I think this should help you if I got your problem right 🙂

See ya,

Thijs van Oorschot
http://www.cryonox.nl

Anon

thanks for that Thijs - however, i am not using a database, just the filesystem - ie. opening a file on the local system and recursing through the contents -

but i think i have solved my own query! - i was converting the 'filemtime' with the date function (to d/m/Y) as i was putting them into the array, which made sorting them impossible - but now i have put them in in the original format, sorted them and converted to date format once i have the latest value - and it seems to work!

🙂