sorting a list in php

[natman3]

I am looking to sort this by name

"SELECT cid, first, last, year, age, invitational, open FROM highschool, users WHERE user_id=$user"

does anyone know how to do this. Above is the statment i am using to display my rows but they are not sorted. I noticed that sql offers a sort function but is there another way i can implement it.

[devinemke]

SELECT cid, first, last, year, age, invitational, open FROM highschool, users WHERE user_id = '$user' ORDER BY name