I have an XML file which follows like this:
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="stylesheet.xsl"?>
<musicmoz>
<category name="bandname1">
<name>bandname1</name>
<release type="album" name="xxx" date="1974" />
<release type="album" name="yyy" date="1977" />
<release type="album" name="zzz" date="1991" />
<release type="album" name="aaa" date="1958" />
</category>
<category name="bandname2">
<name>bandname2</name>
<release type="album" name="xxxx" date="1986" />
<release type="album" name="yyyy" date="1992" />
<release type="album" name="zzzz" date="1939" />
<release type="album" name="aaaa" date="1941" />
<release type="album" name="bbbb" date="1976" />
<release type="album" name="cccc" date="1990" />
<release type="album" name="dddd" date="1990" />
<release type="album" name="eeee" date="1975" />
</category>
.
.
.
</musicmoz>
stylesheet.xsl follows like this:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<body style="font-family:Arial,helvetica,sans-serif;font-size:10pt;background-color:#EEEEEE">
<xsl:text><musicmoz></xsl:text>
<br/>
<xsl:for-each select="musicmoz/category">
<xsl:if test="release/@name">
<xsl:text><category></xsl:text>
<br/>
<xsl:text><artist></xsl:text>
<xsl:value-of select="name"/>
<xsl:text></artist></xsl:text>
<br/>
<xsl:for-each select="release">
<xsl:if test="@type='album'">
<xsl:text><album></xsl:text>
<xsl:value-of select="@name"/>
<xsl:text></album></xsl:text>
<br/>
<xsl:text><date></xsl:text>
<xsl:value-of select="@date"/>
<xsl:text></date></xsl:text>
<br/>
</xsl:if>
</xsl:for-each>
<xsl:text></category></xsl:text>
<br/>
</xsl:if>
</xsl:for-each>
<xsl:text></musicmoz></xsl:text>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
The output I get is like this:
<musicmoz>
<category>
<artist>bandname1</artist>
<album>xxx</album>
<date>1974</date>
<album>yyy</album>
<date>1977</date>
<album>zzz</album>
<date>1991</date>
<album>aaa</album>
<date>1958</date>
</category>
<category>
<artist>bandname2</artist>
<album>xxxx</album>
<date>1986</date>
<album>yyyy</album>
<date>1992</date>
<album>zzzz</album>
<date>1939</date>
<album>aaaa</album>
<date>1941</date>
<album>bbbb</album>
<date>1976</date>
<album>cccc</album>
<date>1990</date>
<album>dddd</album>
<date>1990</date>
<album>eeee</album>
<date>1995</date>
</category>
</musicmoz>
All well and good so far, but how do I get the output to be like this?
<musicmoz>
<category>
<artist>bandname1</artist>
<album1>xxx</album1>
<date1>1974</date1>
<album2>yyy</album2>
<date2>1977</date2>
<album3>zzz</album3>
<date3>1991</date3>
<album4>aaa</album4>
<date4>1958</date4>
</category>
<category>
<artist>bandname2</artist>
<album1>xxxx</album1>
<date1>1986</date1>
<album2>yyyy</album2>
<date2>1992</date2>
<album3>zzzz</album3>
<date3>1939</date3>
<album4>aaaa</album4>
<date4>1941</date4>
<album5>bbbb</album5>
<date5>1976</date5>
<album6>cccc</album6>
<date6>1990</date6>
<album7>dddd</album7>
<date7>1990</date7>
<album8>eeee</album8>
<date8>1995</date8>
</category>
</musicmoz>
Thanks! 
Topic Locked
Posted - 09 February 2006 : 15:14:52
