[thelist] php. finding order
Michael Pemberton
evolt at mpember.net.au
Mon Jan 17 09:07:33 CST 2005
Murat Tutumlu wrote:
> Hi eveybody
>
> I have a table in MySql database. It has student_no,
> Grade, Lesson, and Visa1 columns. I want to echo a
> definite student's order in Visa1 at the same grade
> and for the same lesson.
Try:
"Select student_no, Grade, Lesson, and Visa1 from `table` order by
Lesson, Grade, Visa1"
It will sort then by Grade and Lesson first, so the students in the same
class should be grouped together in the resulting listing.
--
Michael Pemberton
evolt at mpember.net.au
More information about the thelist
mailing list