List:General Discussion« Previous MessageNext Message »
From:Sam Russo Date:January 9 2002 11:24pm
Subject:A difficutl query I cannot do.
View as plain text  
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
Thread
A difficutl query I cannot do.Sam Russo10 Jan
  • Re: A difficutl query I cannot do.Bob Hall10 Jan
  • RE: A difficutl query I cannot do.Gordon13 Jan