EDN Admin
Well-known member
Hi.
I have an XML file of student data which I want to summarise. Basically the file contains student information and their long term goals. Each student belongs to a programme. I need to summarise the data so I can see how many goals have been achieved per
programme and how many have not. Depending on the criteria chosen, different programmes will be output, so the programme list need to be dynamic.
<div style="color:black; background-color:white
<pre><span style="color:blue <?<span style="color:#a31515 xml <span style="color:red version<span style="color:blue =<span style="color:black "<span style="color:blue 1.0<span style="color:black " <span style="color:red encoding<span style="color:blue =<span style="color:black "<span style="color:blue utf-8<span style="color:black " <span style="color:blue ?>
<span style="color:blue <<span style="color:#a31515 EDI<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 EdiHeader<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CollegeName<span style="color:blue >S.... College<span style="color:blue </<span style="color:#a31515 CollegeName<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CreatedDate<span style="color:blue >21/07/2011 15:13<span style="color:blue </<span style="color:#a31515 CreatedDate<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CreatedBy <span style="color:red StaffId<span style="color:blue =<span style="color:black "<span style="color:blue 463<span style="color:black "<span style="color:blue >Philip S...<span style="color:blue </<span style="color:#a31515 CreatedBy<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 EdiHeader<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Students<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Student <span style="color:red StudentId<span style="color:blue =<span style="color:black "<span style="color:blue 256<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Name<span style="color:blue >Ashley A...<span style="color:blue </<span style="color:#a31515 Name<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Firstname<span style="color:blue >Ashley<span style="color:blue </<span style="color:#a31515 Firstname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Surname<span style="color:blue >A...<span style="color:blue </<span style="color:#a31515 Surname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateOfBirth<span style="color:blue >17/08/1984<span style="color:blue </<span style="color:#a31515 DateOfBirth<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Age<span style="color:blue >26<span style="color:blue </<span style="color:#a31515 Age<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Programme <span style="color:red ProgrammeId<span style="color:blue =<span style="color:black "<span style="color:blue 2<span style="color:black "<span style="color:blue >Skills 1<span style="color:blue </<span style="color:#a31515 Programme<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Gender<span style="color:blue >Male<span style="color:blue </<span style="color:#a31515 Gender<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Ethnicity <span style="color:red EthncityId<span style="color:blue =<span style="color:black "<span style="color:blue 6<span style="color:black "<span style="color:blue >Chinese<span style="color:blue </<span style="color:#a31515 Ethnicity<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1533<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >To develop skills, knowledge and understanding to enable him to make informed lifestyle choices<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >True<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >29/01/2004<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1668<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >develop communication skills through the use of a communication aid.<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >22/08/2008<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1673<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >New Long Term Goal<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >21/07/2011<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 Student<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Student <span style="color:red StudentId<span style="color:blue =<span style="color:black "<span style="color:blue 267<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Name<span style="color:blue >Peter A...<span style="color:blue </<span style="color:#a31515 Name<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Firstname<span style="color:blue >Peter<span style="color:blue </<span style="color:#a31515 Firstname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Surname<span style="color:blue >A...<span style="color:blue </<span style="color:#a31515 Surname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateOfBirth<span style="color:blue >18/01/1985<span style="color:blue </<span style="color:#a31515 DateOfBirth<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Age<span style="color:blue >26<span style="color:blue </<span style="color:#a31515 Age<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Programme <span style="color:red ProgrammeId<span style="color:blue =<span style="color:black "<span style="color:blue 3<span style="color:black "<span style="color:blue >Skills 2<span style="color:blue </<span style="color:#a31515 Programme<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Gender<span style="color:blue >Male<span style="color:blue </<span style="color:#a31515 Gender<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Ethnicity <span style="color:red EthncityId<span style="color:blue =<span style="color:black "<span style="color:blue 6<span style="color:black "<span style="color:blue >Chinese<span style="color:blue </<span style="color:#a31515 Ethnicity<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1337<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >Gain skills, knowledge and understanding to live as independently as possible<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >28/07/2003<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1338<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >Further develop his social and communication skills<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >28/07/2003<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 Student<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Student <span style="color:red StudentId<span style="color:blue =<span style="color:black "<span style="color:blue 745<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Name<span style="color:blue >Andrew B...<span style="color:blue </<span style="color:#a31515 Name<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Firstname<span style="color:blue >A...<span style="color:blue </<span style="color:#a31515 Firstname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Surname<span style="color:blue >B...<span style="color:blue </<span style="color:#a31515 Surname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateOfBirth<span style="color:blue >08/11/1983<span style="color:blue </<span style="color:#a31515 DateOfBirth<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Age<span style="color:blue >27<span style="color:blue </<span style="color:#a31515 Age<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Programme <span style="color:red ProgrammeId<span style="color:blue =<span style="color:black "<span style="color:blue 2<span style="color:black "<span style="color:blue >Skills 1<span style="color:blue </<span style="color:#a31515 Programme<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Gender<span style="color:blue >Male<span style="color:blue </<span style="color:#a31515 Gender<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Ethnicity <span style="color:red EthncityId<span style="color:blue =<span style="color:black "<span style="color:blue 20<span style="color:black "<span style="color:blue >British White<span style="color:blue </<span style="color:#a31515 Ethnicity<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1587<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >develop mobility skills in order to move around the College campus.<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >04/02/2004<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1588<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >achieve at least 5 modules in A.L.L.<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >04/02/2004<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 Student<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 Students<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 EDI<span style="color:blue >
[/code]
I need to output this something like this:
<table border="1
<tbody>
<tr>
<th>Programme</th>
<th>Achieved</th>
<th>Unachieved</th>
</tr>
<tr>
<td>Skills 1</td>
<td>1</td>
<td>4</td>
</tr>
<tr>
<td>Skills 2</td>
<td>0</td>
<td>2</td>
</tr>
</tbody>
</table>
I would appreciate any help.
Many thanks
<br/>
View the full article
I have an XML file of student data which I want to summarise. Basically the file contains student information and their long term goals. Each student belongs to a programme. I need to summarise the data so I can see how many goals have been achieved per
programme and how many have not. Depending on the criteria chosen, different programmes will be output, so the programme list need to be dynamic.
<div style="color:black; background-color:white
<pre><span style="color:blue <?<span style="color:#a31515 xml <span style="color:red version<span style="color:blue =<span style="color:black "<span style="color:blue 1.0<span style="color:black " <span style="color:red encoding<span style="color:blue =<span style="color:black "<span style="color:blue utf-8<span style="color:black " <span style="color:blue ?>
<span style="color:blue <<span style="color:#a31515 EDI<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 EdiHeader<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CollegeName<span style="color:blue >S.... College<span style="color:blue </<span style="color:#a31515 CollegeName<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CreatedDate<span style="color:blue >21/07/2011 15:13<span style="color:blue </<span style="color:#a31515 CreatedDate<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CreatedBy <span style="color:red StaffId<span style="color:blue =<span style="color:black "<span style="color:blue 463<span style="color:black "<span style="color:blue >Philip S...<span style="color:blue </<span style="color:#a31515 CreatedBy<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 EdiHeader<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Students<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Student <span style="color:red StudentId<span style="color:blue =<span style="color:black "<span style="color:blue 256<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Name<span style="color:blue >Ashley A...<span style="color:blue </<span style="color:#a31515 Name<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Firstname<span style="color:blue >Ashley<span style="color:blue </<span style="color:#a31515 Firstname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Surname<span style="color:blue >A...<span style="color:blue </<span style="color:#a31515 Surname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateOfBirth<span style="color:blue >17/08/1984<span style="color:blue </<span style="color:#a31515 DateOfBirth<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Age<span style="color:blue >26<span style="color:blue </<span style="color:#a31515 Age<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Programme <span style="color:red ProgrammeId<span style="color:blue =<span style="color:black "<span style="color:blue 2<span style="color:black "<span style="color:blue >Skills 1<span style="color:blue </<span style="color:#a31515 Programme<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Gender<span style="color:blue >Male<span style="color:blue </<span style="color:#a31515 Gender<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Ethnicity <span style="color:red EthncityId<span style="color:blue =<span style="color:black "<span style="color:blue 6<span style="color:black "<span style="color:blue >Chinese<span style="color:blue </<span style="color:#a31515 Ethnicity<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1533<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >To develop skills, knowledge and understanding to enable him to make informed lifestyle choices<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >True<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >29/01/2004<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1668<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >develop communication skills through the use of a communication aid.<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >22/08/2008<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1673<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >New Long Term Goal<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >21/07/2011<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 Student<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Student <span style="color:red StudentId<span style="color:blue =<span style="color:black "<span style="color:blue 267<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Name<span style="color:blue >Peter A...<span style="color:blue </<span style="color:#a31515 Name<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Firstname<span style="color:blue >Peter<span style="color:blue </<span style="color:#a31515 Firstname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Surname<span style="color:blue >A...<span style="color:blue </<span style="color:#a31515 Surname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateOfBirth<span style="color:blue >18/01/1985<span style="color:blue </<span style="color:#a31515 DateOfBirth<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Age<span style="color:blue >26<span style="color:blue </<span style="color:#a31515 Age<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Programme <span style="color:red ProgrammeId<span style="color:blue =<span style="color:black "<span style="color:blue 3<span style="color:black "<span style="color:blue >Skills 2<span style="color:blue </<span style="color:#a31515 Programme<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Gender<span style="color:blue >Male<span style="color:blue </<span style="color:#a31515 Gender<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Ethnicity <span style="color:red EthncityId<span style="color:blue =<span style="color:black "<span style="color:blue 6<span style="color:black "<span style="color:blue >Chinese<span style="color:blue </<span style="color:#a31515 Ethnicity<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1337<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >Gain skills, knowledge and understanding to live as independently as possible<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >28/07/2003<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1338<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >Further develop his social and communication skills<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >28/07/2003<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 Student<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Student <span style="color:red StudentId<span style="color:blue =<span style="color:black "<span style="color:blue 745<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Name<span style="color:blue >Andrew B...<span style="color:blue </<span style="color:#a31515 Name<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Firstname<span style="color:blue >A...<span style="color:blue </<span style="color:#a31515 Firstname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Surname<span style="color:blue >B...<span style="color:blue </<span style="color:#a31515 Surname<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateOfBirth<span style="color:blue >08/11/1983<span style="color:blue </<span style="color:#a31515 DateOfBirth<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Age<span style="color:blue >27<span style="color:blue </<span style="color:#a31515 Age<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Programme <span style="color:red ProgrammeId<span style="color:blue =<span style="color:black "<span style="color:blue 2<span style="color:black "<span style="color:blue >Skills 1<span style="color:blue </<span style="color:#a31515 Programme<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Gender<span style="color:blue >Male<span style="color:blue </<span style="color:#a31515 Gender<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Ethnicity <span style="color:red EthncityId<span style="color:blue =<span style="color:black "<span style="color:blue 20<span style="color:black "<span style="color:blue >British White<span style="color:blue </<span style="color:#a31515 Ethnicity<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1587<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >develop mobility skills in order to move around the College campus.<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >04/02/2004<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LongTermGoal <span style="color:red LtgId<span style="color:blue =<span style="color:black "<span style="color:blue 1588<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Goal<span style="color:blue >achieve at least 5 modules in A.L.L.<span style="color:blue </<span style="color:#a31515 Goal<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Achieved<span style="color:blue >False<span style="color:blue </<span style="color:#a31515 Achieved<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DateSet<span style="color:blue >04/02/2004<span style="color:blue </<span style="color:#a31515 DateSet<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoal<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LongTermGoals<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 Student<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 Students<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 EDI<span style="color:blue >
[/code]
I need to output this something like this:
<table border="1
<tbody>
<tr>
<th>Programme</th>
<th>Achieved</th>
<th>Unachieved</th>
</tr>
<tr>
<td>Skills 1</td>
<td>1</td>
<td>4</td>
</tr>
<tr>
<td>Skills 2</td>
<td>0</td>
<td>2</td>
</tr>
</tbody>
</table>
I would appreciate any help.
Many thanks
<br/>
View the full article