hi i’m having trouble with my code, This is how it is outputting:
<?xml version=“1.0” encoding=“utf-8” standalone=“yes” ?>
- <images>
- <pic>
<image>flash/xmlimages/wave.jpg</image>
<caption>Etnies</caption>
<image>flash/xmlimages/chickboard.jpg</image>
<caption>Hello</caption>
<image>flash/xmlimages/babe.jpg</image>
<caption>Swim Wear</caption>
</pic>
</images>
but i need it to output like this:
<?xml version=“1.0” encoding=“utf-8” standalone=“yes” ?>
- <images>
- <pic>
<image>flash/xmlimages/wave.jpg</image>
<caption>Etnies</caption>
</pic>
<pic>
<image>flash/xmlimages/chickboard.jpg</image>
<caption>Hello</caption>
</pic>
<pic>
<image>flash/xmlimages/babe.jpg</image>
<caption>Swim Wear</caption>
</pic>
</images>
heres my code:
<?php
header("Content-type: text/xml");
include ("connect.php");
$xml_output = "<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"yes\"?>
";
$xml_output .= "<images>
";
//images
$result = mysql_query("select * from flashgal");
$xml_output .= " <pic>
";
for($x = 0 ; $x < mysql_num_rows($result) ; $x++){
$row = mysql_fetch_assoc($result);
$xml_output .= " <image>". $row['image'] ."</image>
";
$xml_output .= " <caption>". $row['caption'] ."</caption>
";
}
$xml_output .= " </pic>
";
$xml_output .= "</images>";
echo $xml_output;
?>