Harald Fuchs wrote:
"Sam Russo" <[EMAIL PROTECTED]> writes:
I recieve a delimited file whose fields are:
day,slot,subject,room
An example of this file is:
2,1,Mat,R1
3,1,Sci,R6
1,2,Sci,R6
3,2,Mat,R3
1,3,Eng,R2
2,3,Eng,R5
1,4,Mat,R7
3,4,Eng,R9
I need a mysql query that will generate a timetable whi
In article <[EMAIL PROTECTED]>,
"Sam Russo" <[EMAIL PROTECTED]> writes:
> I recieve a delimited file whose fields are:
> day,slot,subject,room
> An example of this file is:
> 2,1,Mat,R1
> 3,1,Sci,R6
> 1,2,Sci,R6
> 3,2,Mat,R3
> 1,3,Eng,R2
> 2,3,Eng,R5
> 1,4,Mat,R7
> 3,4,Eng,R9
> I need a mysql que
usso"
<[EMAIL PROTECTED]> To: [EMAIL PROTECTED]
cc:
06/1
I recieve a delimited file whose fields are:
day,slot,subject,room
An example of this file is:
2,1,Mat,R1
3,1,Sci,R6
1,2,Sci,R6
3,2,Mat,R3
1,3,Eng,R2
2,3,Eng,R5
1,4,Mat,R7
3,4,Eng,R9
I need a mysql query that will generate a timetable which looks like:
Day1Day2Day3
