PHP/XML

[gw32]

How do I get mySql data variables into this XML file?

I've tried but get failure after failure.

 

<?xml version="1.0" encoding="UTF-8"?>

<Carousel>
<photo image="images/main/bridal.jpg" url="http://tegodev.tegojewelers.com/Bridal/index.php" target="_self"><![CDATA[bridal]]></photo>
</Carousel>

 

I need to have this:

    main = $directory;

    bridal.jpg = $name;

    Bridal = $path;

 

I can get all of the variables from the DB table no problem, but don't know enough about XML to put in variables.

 

Thanks