MySql to xml

[Roberto25]

Hey,

I have a problem with export data from mysql in xml. I need create for every id new xml.. like: video_$id.xml .. Please for help!!

 

$query = "SELECT * FROM videos ORDER BY id";

$result = mysql_query($query) or die('Error : ' . mysql_error());

$row = mysql_fetch_assoc($result);

 

$files = "test/" . $row['id'] . ".xml"; // this create 1.xml and parse all mysql data

$fh = fopen($files, 'w') or die("can't open file");

 

fwrite($fh,'<videos>');

 

while ($row = @mysql_fetch_assoc($result)){

fwrite($fh,'<video>');

fwrite($fh,"<id>" . $row['id'] . "</id>\n");

fwrite($fh,"<title>" . $row['title'] . "</title>\n");

fwrite($fh,"<link>" . $row['videolink'] . "</link>\n");

fwrite($fh, '</video>');

}

 

fwrite($fh, '</videos>');

fclose($fh);

 

query($result);

mysql_close()