alphabetization in a script

[mufka]

I have a php script that is querying a MySQL database and printing a list of all of the desired fields. The list is alphabetized. If I add new data to the database, the script then doesn't properly alphabetize the data. It keeps all of the entries with the correct letter (all the A's are together) but the items are not alphabetized within each letter (the new entries beginning with A are at the end of the A's). Is there something I can do in the query to get it to alphabetize correctly?

 

[sleipnir214]

Unless you specify an ORDER BY clause in your query, you are not guaranteed the resultset returned by a SELECT query will have any order. SQL is based on set theory and as such does not place any kind of implicit order on the data.


Want the best answers? Ask the best questions! TANSTAAFL!

 

[mufka]

I do have an ORDER BY in the query.

 

[sleipnir214]

Then there is likely something not quite right about your ORDER BY clause. I have a MySQL dictionary table with more than 100,000 words in it and when I add "aab" to the table then perform a select with the clause "ORDER BY word", "aab" appears exactly where it should.


Want the best answers? Ask the best questions! TANSTAAFL!

 

[sleipnir214]

I think your question is about MySQL queries and not PHP, you should be discussion this in the MySQL forum: forum436


Want the best answers? Ask the best questions! TANSTAAFL!