<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
	<s:Schema id="RowsetSchema">
		<s:ElementType name="row" content="eltOnly" rs:CommandTimeout="30">

			<s:AttributeType name="myDates" rs:number="6" rs:nullable="true" rs:writeunknown="true">
				<s:datatype dt:type="dateTime" rs:dbtype="timestamp" dt:maxLength="16" rs:scale="0" rs:precision="19" rs:fixedlength="true"/>
			</s:AttributeType>

			<s:AttributeType name="Net" rs:number="29" rs:nullable="true" rs:writeunknown="true">
				<s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="2" rs:precision="10" rs:fixedlength="true"/>
			</s:AttributeType>

			<s:extends type="rs:rowbase"/>
		</s:ElementType>
	</s:Schema>
	<rs:data>

		<z:row myDates="2011-05-13T21:50:00" Net=".00" />

	</rs:data>
</xml>

<!-- #include virtual="/_XML/adovbs.inc" -->

<% 

filename = "titty.xml" 

Set xmlDoc = CreateObject("MSXML2.DOMDocument.4.0")
Set xslDoc = CreateObject("MSXML2.DOMDocument.4.0")

%>

<%

sql = "SELECT * FROM tbl_login" 
Set rs = objConn.Execute(sql) 

rs.Save xmlDoc, 1 

xmlDoc.Save Server.MapPath(filename)

rs.Close 
Set rs = Nothing 

%>

<%

 Set oDOM = CreateObject("MSXML2.DOMDocument.4.0")
 oDOM.async = False 
 
 oDOM.Load Server.Mappath(filename)
  
 Set oXSL = CreateObject("MSXML2.DOMDocument.4.0") 
 oXSL.async = False 
 
 oXSL.Load Server.Mappath("Trasform_csv.xsl") 
 
 strTransform = oDOM.transformNode(oXSL) 
 
 Set fso = CreateObject("Scripting.FileSystemObject")
 strPath = Server.Mappath("testme.csv")
  
 Set file = fso.opentextfile(strPath, 2, True)
 file.write strTransform

 file.Close 
 Set file = Nothing
  
 Set fso = Nothing
                        
 Set oDOM = Nothing 
 Set oXML = Nothing 
 Set oXSL = Nothing 
  
%>

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" 
 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; 
 xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" 
 xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" 
 xmlns:rs="urn:schemas-microsoft-com:rowset" 
 xmlns:z="#RowsetSchema">
	<xsl:output omit-xml-declaration="yes"/>
	<xsl:template match="/">
		<!-- show a header by looking Schema element -->
		<xsl:for-each select="/xml/s:Schema/s:ElementType/s:AttributeType">
			<xsl:value-of select="@name"/>
			<xsl:choose>
				<xsl:when test="position()!=last()">
  				    <!-- xls -->
					<xsl:text>&#x09;</xsl:text>
					<!-- csv -->
					<!--xsl:text>,</xsl:text-->
				</xsl:when>
				<xsl:otherwise>
					<xsl:text>&#xa;</xsl:text>
				</xsl:otherwise>
			</xsl:choose>
		</xsl:for-each>
		<!-- row data -->
		<xsl:for-each select="/xml/rs:data/z:row">
      <xsl:variable name="row" select="."/>
      <!-- for each column -->
			<xsl:for-each select="/xml/s:Schema/s:ElementType/s:AttributeType">
			   <!-- display each column if it exists -->
			  <xsl:variable name="columnName" select="@name"/>
				<!-- go through all columns and display something that matches-->
				<xsl:value-of select="$row/@*[name()=$columnName]" />
				<!--xsl:value-of select="translate($row/@*[name()=$columnName],'.',',')" /-->
				<xsl:if test="position()!=last()">
				    <!-- xls -->
					<xsl:text>&#x09;</xsl:text>
					<!-- csv -->
					<!--xsl:text>,</xsl:text-->
				</xsl:if>
	    </xsl:for-each>
			<xsl:text>&#xa;</xsl:text>
	  </xsl:for-each>
	</xsl:template>
</xsl:stylesheet>

<z:row myDates="13/05/2001 21:50:00" Net="0.00" />

13/05/2001 21:50:00, 0

<?php
include("config.php");

echo "<Carousel>\n";

 $path = "http://abcd.com/";; 

$sql = "(select a.im_name, a.description, b.name from images a, department b where a.dpt_id = '$pid' and a.dpt_id = b.dpt_id)";

$result = mysql_query($sql);

while($row = mysql_fetch_array($result))
  	{
  		/* This works */
  		print $row['im_name'];
  		print "&nbsp;";
  		print $row['name'];
  		print "&nbsp;";
  		print $row['description'];
  		print "<br>";
  		/* end works */
	} 
	//* Somehow I need to plug the above into the below, Every time I try I get ERRORS *//
	//* <photo image="images/(im_name)" url="(path)/(name)/index.php" target="_self"><![CDATA[(description)]]></photo> *//


echo "</Carousel>\n";

mysql_close($dbh);
?>

I just need this fixed:
<photo image="images/(im_name)" url="(path)/(name)/index.php" target="_self"><![CDATA[(description)]]></photo>

Using $row['im_name'] for (im_name) and
$path = "http://abcd.com/"; for (path)
$row['name'] for (name) and
$row['description'] for (description).

I tried this:
		echo "<photo image=\"".$path."images/".$row['im_name']."\"";
		echo "url=\"".$path.$row['name']."/index.php\" target=\"_self\">";
		echo "<![CDATA[".$row['description']."]></photo>";

and nothing, no data or I get a syntax error.

Thank you