Displaying 1st Entry
Posted: Sun Feb 11, 2007 5:01 am
Hey guys,
I have a page where a single database entry is shown by changing the value of a drop-down menu. How would I display the first alphabetically ordered entry in the database without having to submit the dropdown menu form? The ID (auto-increment) field may not always be 1 as entries can be deleted, so I'm thinking that I should bypass the dropdown at first load but not sure how to word the sql query to display first entry in alphabetical order only.
Thanks
I have a page where a single database entry is shown by changing the value of a drop-down menu. How would I display the first alphabetically ordered entry in the database without having to submit the dropdown menu form? The ID (auto-increment) field may not always be 1 as entries can be deleted, so I'm thinking that I should bypass the dropdown at first load but not sure how to word the sql query to display first entry in alphabetical order only.
Thanks