Sorting

[Hector]

Is there a way to sort the entries in the database by date. I use curdate(); to enter the date.

[Defender1]

First off, there's no mention of curdate() on php.net. Is that a custom made function?

and if your storing the date as a date/time field, you can sort them when you pull the record from your database.
and example query would look like this:

SELECT * from tablename order by column_name ASC

Where tablename is the table you want to get it from and column_name is the column that you want to sort by. ASC is ascending order, and DESC would sort it by descending order.

Though i'd need to know the specifics to make this work.
Like the type of the field, how the date is being stored etc.

[seanf]

Originally posted by Defender1
First off, there's no mention of curdate() on php.net. Is that a custom made function?

Curdate() is a MySQL function to return today's date

More info here:
http://www.mysql.com/doc/D/a/Date_an...functions.html

Sean

[Hector]

Thx defender. It worked perfectly.