Alphabetize query?

[Anon]

ok... I\'m using the code

\"$query=mysql_query(\"SELECT * FROM plants WHERE nur_flor=\'nur\' ORDER BY Name\");\"

to grab data from my database... but when i connect to my php file... only 2 of my queries come up in alphabetical order.... its the same code... whats up with that?

is ther a code to order all alphabetically... right now they\'re all \"order by name\"....

Please help,

Thanks

[biggus]

Matt,

try "...order by name asc" to sort ascending.

HTH