displaying by date

[hamburgerlove41]

hello,
I've looked and looked, but cant find the answer to this very simple problem, so hopefully someone can help me. All I want to do is to, using a form, send data to the database( i can do that already), but then i want to display only one line from the database, based on the date. ive got everything down, except getting the line to show up by it's date. How do i do this??

[planetsim]

Can you show us what you got so far and how is the date stored?

[hamburgerlove41]

right now, i just have an input box where i type the current date (yyyy-mm-dd), and it goes to a timestamp field in the table. then i had the info being displayed set to be ordered by that date. This was working fine, until just a few weeks ago, when all of a sudden it wasnt counting the latest date as the latest date, and was staying as an entry from a previous date.
so what i have so far is a table with the following fields:

time
day
speaker
date (timestamp)

i dont even want to display the date anywhere, i just want it ordered by the date it was entered. is there an easier way to do this??

[hamburgerlove41]

anyone??