Easiest way to append a time to a submittal via php to mysql

[twilightnights]

I have a submittal form and I want to append a time when it was submitted.  I would also be able to make a query and sort by time so I can show newest on my web page.  Can anyone help help me with this?

[shocker-z]

just create a TIME field in your database and when inserting into the database use CURTIME() in the SQL

and to order when retreiving the data append "SORT BY timefield ASC" to your query

Regards
Liam

[pocobueno1388]

You could use a DATETIME field.

To insert the time in the database you would use NOW()

ex:

[code]

INSERT INTO table (time) VALUES ( NOW()));

[/code]

If you just used a time field and sorted by the time it was submitted, I would think it would get all mixed up the next day beacause it doesn't know the date it was submitted as well.

[twilightnights]

does curtime include date, month, year, etc? Or do you have to make seperate fields for each of these.  Not exactly sure how searching would work with this.. for example 12232005 is greater mathematically to 09232006

[twilightnights]

Also what datatype should I use in the mysql database, just store is as an int? there are a bunch of date/time things it seems a little confusing on how it would work with the php code.

[pocobueno1388]

DATETIME includes the date/month/year and time if that is what you want. In the database you would just store the field under DATETIME.

[twilightnights]

oh thanks a lot, I complete missed that you said above to make it a date time field.  Worked like a charm, ty.