I am very much a beginer in ASP. Today I thought I wannted to fiddle around with my ASP script. So, I want to display the items in alphabetical order.. Can any one edit the following code to display the links generated in Alphabetical order???
You could change the order by clause in your select statement sql1="select * from tbl_reviews order by rev_title asc" Code (markup):
Thts for ascending order if Im not wrong... I want to display them Alphabetically... How do I do that???
That is how you would sort them alphabetically. sql1="select * from TABLE_NAME order by ROW_NAME asc" Code (markup): THE "order by ROW_NAME asc" tells your script to sort it alphabetically by ROW_NAME in ascending order
okay I tried this... And It doesnt work... It executed as I had expected... The ordering just over turned... Currently the links occur according to a order as and when new ones are created. 'desc' and 'asc' are only changin the order from latest to oldest or oldest to latest.... But I want to show my links in alphabetical order.. and not chronological order [according to their dates of creating].
Venom was correct with sql1="select * from tbl_reviews order by rev_title asc" Notice that he has changed rev_posted to rev_title You don't actually need to add asc as this is the default, so sql1="select * from tbl_reviews order by rev_title " will do.