[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