Display information in a time table format

[g_0010662]

I am very new to xml programming so please help.
This is the xml file I get generated from xsql. This is all the modules a particular student studies on their course.

<?xml version = '1.0'?>
<ROWSET>
<ROW num="1">
<CRN>46534 </CRN>
<GROUP_CODE>A </GROUP_CODE>
<CLASS_TYPE>Prac </CLASS_TYPE>
<FIRST_NAME>Guy</FIRST_NAME>
<SECOND_NAME>Duong</SECOND_NAME>
<START_TIME>12</START_TIME>
<END_TIME>13</END_TIME>
<SCHEDULED_DAY>Tuesday </SCHEDULED_DAY>
<ROOM_NUMBER>BP JG214 </ROOM_NUMBER>
<MODULE_NAME>Advanced Database Management</MODULE_NAME>
</ROW>
<ROW num="2">
<CRN>46534 </CRN>
<GROUP_CODE>N/A </GROUP_CODE>
<CLASS_TYPE>Lect </CLASS_TYPE>
<FIRST_NAME>Guy</FIRST_NAME>
<SECOND_NAME>Duong</SECOND_NAME>
<START_TIME>11</START_TIME>
<END_TIME>12</END_TIME>
<SCHEDULED_DAY>Tuesday </SCHEDULED_DAY>
<ROOM_NUMBER>BP JGG11 </ROOM_NUMBER>
<MODULE_NAME>Advanced Database Management</MODULE_NAME>
</ROW>
<ROW num="3">
<CRN>46535 </CRN>
<GROUP_CODE>A </GROUP_CODE>
<CLASS_TYPE>Prac </CLASS_TYPE>
<FIRST_NAME>Guy</FIRST_NAME>
<SECOND_NAME>Duong</SECOND_NAME>
<START_TIME>11</START_TIME>
<END_TIME>12</END_TIME>
<SCHEDULED_DAY>Wednesday </SCHEDULED_DAY>
<ROOM_NUMBER>BP JG214 </ROOM_NUMBER>
<MODULE_NAME>Advanced Database Programming</MODULE_NAME>
</ROW>
<ROW num="4">
<CRN>46535 </CRN>
<GROUP_CODE>N/A </GROUP_CODE>
<CLASS_TYPE>Lect </CLASS_TYPE>
<FIRST_NAME>Guy</FIRST_NAME>
<SECOND_NAME>Duong</SECOND_NAME>
<START_TIME>10</START_TIME>
<END_TIME>11</END_TIME>
<SCHEDULED_DAY>Wednesday </SCHEDULED_DAY>
<ROOM_NUMBER>BP PRG09 </ROOM_NUMBER>
<MODULE_NAME>Advanced Database Programming</MODULE_NAME>
</ROW>
<ROW num="5">
<CRN>46550 </CRN>
<GROUP_CODE>N/A </GROUP_CODE>
<CLASS_TYPE>Lect </CLASS_TYPE>
<FIRST_NAME>Guy</FIRST_NAME>
<SECOND_NAME>Duong</SECOND_NAME>
<START_TIME>14</START_TIME>
<END_TIME>15</END_TIME>
<SCHEDULED_DAY>Thursday </SCHEDULED_DAY>
<ROOM_NUMBER>BP JGG11 </ROOM_NUMBER>
<MODULE_NAME>Individual Project</MODULE_NAME>
</ROW>
<ROW num="6">
<CRN>46847 </CRN>
<GROUP_CODE>A </GROUP_CODE>
<CLASS_TYPE>Tut </CLASS_TYPE>
<FIRST_NAME>Guy</FIRST_NAME>
<SECOND_NAME>Duong</SECOND_NAME>
<START_TIME>10</START_TIME>
<END_TIME>12</END_TIME>
<SCHEDULED_DAY>Monday </SCHEDULED_DAY>
<ROOM_NUMBER>BP CA123 </ROOM_NUMBER>
<MODULE_NAME>Online Communities</MODULE_NAME>
</ROW>
</ROWSET>

How could I get this file to display on the web in timetable format with the correct information in the right slots?
For example the information on the module indivdual project will be in the slot thursday at 2 to 3.

9 to 10 |11 to 12 |12 to 1 1 to 2 |2 to 3|

Monday

Tuesday

Wednesday

Thursday

Friday

Thanks in advance for anyone who can solve this problem!

[g_0010662]

I know you use a stylesheet but how do I get about doing it. I dont even know where to start. Is it even possible to do with XLST? Can someone please reply :confused:

[Alex Vincent]

It's not only possible, but I think in this case it's required.

The problem, I see, is in these lines:

<START_TIME>12</START_TIME>
<END_TIME>13</END_TIME>


This is particularly troublesome because this is a descendant of what you want styled, and CSS doesn't handle that well (if at all).

You want that to appear in a column headed with:

12 to 1

CSS can style to your heart's content, but this is really complex for a table matching your specifications, from a CSS point of view.

If you were able to generate more attributes instead of child elements, it would be much easier to do with CSS. Then you would output only the child elements you would want as table cells.