I have a delimited file sent to me with students ID subjects and when they
do these subjects. This file (table) looks like:
ID TimeSlot Subject
++++++++++++++++++++++++++++++++++++
215 3 Eng1
648 2 Maths2
901 4 French
215 2 Maths1
901 1 Science2
648 4 Art
215 1 Science1
901 3 Eng1
I need to produce the following output (on a web page using php and
mysql) with a mysql query.
ID 1 2 3 4
215 Science1 Maths1 Eng1
648 Maths2 Art
901 Science2 Eng1
French
any help would be appreciated.
sam russo
samrusso@stripped