Alphabetical ordering ----- HOW TO ?????
Posted: Mon Dec 23, 2002 10:39 pm
Hi everyone
Happy Xmas
Here is what I am battling with. I have a table that will contain names and other info. The content will be displayed on a page, and I need it to be alphabetically ordered. How to do this??????
I was thinking that there is probably a sort() function in php that I can use to alphabetically order the results of the query. However this means that on every hit, the function would be ran which is kind of a waste of ressources.
Second, I though it would be best if the info in the table was already alphabetically ordered so I can directly display the result of the query. Can this be done???? Is there a command in MySQL to alphabetically order entries???? If there is, when new info is added in the table, can it also be used to place the data appropriatelly?????
Thank you very much for any sugestions.
Huge
Happy Xmas
Here is what I am battling with. I have a table that will contain names and other info. The content will be displayed on a page, and I need it to be alphabetically ordered. How to do this??????
I was thinking that there is probably a sort() function in php that I can use to alphabetically order the results of the query. However this means that on every hit, the function would be ran which is kind of a waste of ressources.
Second, I though it would be best if the info in the table was already alphabetically ordered so I can directly display the result of the query. Can this be done???? Is there a command in MySQL to alphabetically order entries???? If there is, when new info is added in the table, can it also be used to place the data appropriatelly?????
Thank you very much for any sugestions.
Huge