\n"; $xml_output .= "\n"; while ($row = mysql_fetch_assoc($resultID)) { $xml_output .= "\t\n"; $xml_output .= "\t\t" . $row['fileName'] . "\n"; $xml_output .= "\t\t" . $row['fileExt'] . "\n"; $xml_output .= "\t\t" . $row['costCode'] . "\n"; $xml_output .= "\t\t" . $row['exposureTime'] . "\n"; $xml_output .= "\t\t" . $row['fNumber'] . "\n"; $xml_output .= "\t\t" . $row['dateTaken'] . "\n"; $xml_output .= "\t\t" . $row['width'] . "\n"; $xml_output .= "\t\t" . $row['height'] . "\n"; $xml_output .= "\t\t" . $row['manufacturer'] . "\n"; $xml_output .= "\t\t" . $row['model'] . "\n"; $xml_output .= "\t\t" . $row['colourSpace'] . "\n"; $xml_output .= "\t\t" . $row['lightSource'] . "\n"; $xml_output .= "\t\t" . $row['flash'] . "\n"; $xml_output .= "\t\t" . $row['meteringMode'] . "\n"; $xml_output .= "\t\n"; } $xml_output .= ""; echo $xml_output; ?>