Forums

ASP

This topic is locked

ASP SQL Query

Posted 08 Nov 2006 16:36:15
1
has voted
08 Nov 2006 16:36:15 Steve Bedder posted:
Hi,

I've got a SQL database that contains the following columns - Course, January, February, March, April etc plus other columns.

There will be multiple records for the same course name e.g.

January February March April
course1 10-13
course1 20-21
course1 1-5
course2 13-12
course2 9-6

On my page, I want to be able to show the following:

January February March April
course1 10-13 20-21 1-5
course2 13-12 9-6

I've been trying for days to try and get this to work, I can get somewhere close, but not the whole way.

Anyone any advice or suggestions?

Thanks in advance

Steve

Reply to this topic