When I display something on a PHP page that is taken from a MYSQL database, how is it possible to alphabetize the data. The data in each row is separated by a column. ANY HELP? THANKS!!!;)

You probably have to ORDER BY some column.

Hello:

Here's a good tutorial i would recommend you look through:

http://www.freewebmasterhelp.com/tutorials/phpmysql/6

Hope it helps.

Thanks!

The thing is, the data is one field, like TABLE 1 row1.col2 the data that is displayed needs to be alphabetized.

Could you; query the database, get the results in an array using mysql_fetch_array or similar (you'd want to use the MYSQL_ASSOC type, otherwise you'd get numerics aswell), then use the sort() function to sort into alphabetical order?

I've not tried this...but I can't see why it wouldn't work.

Originally posted by iamdave
The thing is, the data is one field, like TABLE 1 row1.col2 the data that is displayed needs to be alphabetized.
Then just order by that field.

Originally posted by Vulture
Could you; query the database, get the results in an array using mysql_fetch_array or similar (you'd want to use the MYSQL_ASSOC type, otherwise you'd get numerics aswell), then use the sort() function to sort into alphabetical order?

I've not tried this...but I can't see why it wouldn't work. That would probably be the best solution.

That would probably be the best solution.
It wouldnt - shifting the sorting logic to the database is better since this isnt a special case.