Quick Question about Date Ordering

[tony_l]

I have a script that I just wrote that uses the getdate(time())function/argument. What I did was have the script format the date into month/day/year going the long way about it. Now I have a problem.

When the date is placed in the Database it does not do anything useful, because when it lists the members join date, it does not order them correctly 🙁. This is because I used the TEXT field, but when I change it to a DATE field it lists it funny.

Basically this is what I need to do: get the date the member fills out their profile and then stick it in the MYSQL database so that when I query the database and have it order the results by date it will do it.

[adamd1]

"Lists it funny" how?

Why not just auto-enter the date (in the spanky new datetime or date field in the database) by going:

INSERT INTO tablename SET
name = '$name',
(etc etc),
enterdate = now();

The "now()" constant will snapshot the exact second the person entered the data, and it's sortable:

SELECT name FROM tablename ORDER BY enterdate DESC;

Ta da

ad