PHP MySQL sort by date?

[blckspder]

Hello
I have a page that we are trying to database.. Its a trade show page has the list of the shows and the dates of them. well we want the form to update automatically by using a form processed by php and MySQL. So I was wondering if there was a way when entering the data into MySQL through the form that the shows would sort by recent dates to long range dates automatically instead of sorting it when you call the table to view the shows? Can this be done?? Im not sure if Im explaining it clear enough. Let me know Thanks...

P.S. here is the link for the existing Trade show page that we have to update by going into the html code.

http://www.sono-tek.com/shows/shows.php

Thanks again

[Roger_Ramjet]

Data gets stored in a database table in exactly the same order that it was entered, ie new records go on the end.

What we do is to designate a Primary Key on one or more columns and this becomes the default sort order for the table. Now a primary key must be unique so you would have problems using your start date column for that: you would only be able to have 1 event per date if you did and I don't think that will work. You'll just have to create an index on the start date column and use an ORDER BY clause in your query.

[blckspder]

ok I'll look into that. Thanks