XML & PHP & MySQL & Flash

[maskme]

Dear All

Flash is reading photos from XML.
Now i want to make XML dynamic I want to run while loop into XML for retrieving data.

<?xml version="1.0" encoding="iso-8859-1"?>
<image>
	<section name="one">
		<file src="image/airport1_one.jpg" thumb="thumb/airport1_one.jpg" />
		<file src="image/airport2_one.jpg" thumb="thumb/airport2_one.jpg" />
		<file src="image/airport3_one.jpg" thumb="thumb/airport3_one.jpg" />
		<file src="image/airport4_one.jpg" thumb="thumb/airport4_one.jpg" />
		<file src="image/airport5_one.jpg" thumb="thumb/airport5_one.jpg" />
		<file src="image/airport6_one.jpg" thumb="thumb/airport6_one.jpg" />
		<file src="image/airport7_one.jpg" thumb="thumb/airport7_one.jpg" />
		<file src="image/airport8_one.jpg" thumb="thumb/airport8_one.jpg" />
</section>
</image>

For e.g. I want to give values of <file src=""> from database.

Regards

[NogDog]

xml.php:

<?php
header("Content-Type: text/xml");
?>
<?xml version="1.0" encoding="iso-8859-1"?>
<image>
  <section name="one">
<?php
// query your database, then....
while($row = mysql_fetch_assoc($result))
{
   printf("    <file src='image/%s' thumb='thumb/%s' />\n", $row['image'], $row['thumb']);
}
?>
  </section>
</image>