k.. How would i go around choosing a particular "collum" in MySql and all the vaules listed in are sorted alpabeticaly
lets say I have
ID | Name | Somevalue |
1 | apple | b
2 | zebra | q
3 | bananna | 21
pretty crude table huh?
lets say i want the values rearanged so its
1 apple b
3 bananna 21
2 zebra q
I want the name collum to be sorted alphabeticly
Whats the advice oh great php gods!
(or at least point me in the right direction)
During your SQL query use ORDER BY fieldname, here's a nice little tutorial on ORDER BY :
$sql = mysql_query ("SELECT * FROM $table ORDER BY Name");