Exporting data from mysql in the xml using php

[kenny_sk8]

i am trying to export the data from mysql db into a specific xml format, using php.i have created like this.if i do like this, i get proper output of a $string in xml.\[code\]<?php$string = <<<_XML_<videos><updated>2010-07-20T00:00:00Z</updated><video> <id>id</id> <title>title</title> <description>description</description> <tags>Comma,Separated,Keywords,Go,Here</tags> <paysite>Name Of site</paysite> <clip_url>http://www.domain.com/path/to/videos/</clip_url> <screen_url>http://www.domain.com/path/to/thumbnails/</screen_url> <clips> <clip> <duration>20</duration> <width>640</width> <height>480</height> <flv>marta_123.flv</flv> <screens> <screen>marta.jpg</screen> </screens> </clip> <clip> <duration>20</duration> <width>640</width> <height>480</height> <flv>jenna_123.flv</flv> <screens> <screen>jenna.jpg</screen> </screens> </clip> <clip> <duration>123</duration> <width>640</width> <height>480</height> <flv>kathy_123.flv</flv> <screens> <screen>kathy.jpg</screen> </screens> </clip> </clips> </video></videos>_XML_;$xml = new SimpleXMLElement($string);Header('Content-type: text/xml');echo $xml->asXML();?>\[/code\]but if i try to pull values from db and put in the same hierarchy it doesnt output data in xml. like this\[code\] <?php $dbh=mysql_connect($localhost, $username, $password) or die ('I cannot connect to the database because: ' . mysql_error()); $result = mysql_query("SELECT * FROM 12345_flv.flv WHERE enabled = '1' ORDER BY id DESC") or die('Could not connect: ' . mysql_error()); $string = '<<<_XML_<videos><updated>2010-07-20T00:00:00Z</updated><video>'; while ($row = mysql_fetch_array($result)) { $id=$row['id']; $title=$row['title']; $string .='<id>'.$id.'</id>'; $string .='<title>'.$title.'</title>'; } $string .='</video></videos>_XML_'; $xml = new SimpleXMLElement($string); Header('Content-type: text/xml');echo $xml->asXML();?>\[/code\]its output shows <<<XML in the page source .what i am doing wrong.all i want is export the data from mysql into xml using php.thanks for your time