MunkiWeb manifest php script

<?php
mysql_connect("localhost", "USER", "PASS") or die(mysql_error());
mysql_select_db("munkiwebadmin") or die(mysql_error());

$udmanifest = mysql_real_escape_string($_GET[udmanifest]);

$result = mysql_query("SELECT * FROM reports_munkireport");

//echo $row['report'];

//preg_match('/<key>ManifestName<\/key>.*?<string>(.*?)<\/string>/s', $row['report'], $matches );
//print_r($matches);

	echo "<table border='1'>";
	echo "<tr>";
	echo "<th>Hostname</th>";
	echo "<th>Manifest</th>";
	echo "</tr>";

while($row = mysql_fetch_array($result)){

	preg_match('/<key>hostname<\/key>.*?<string>(.*?)<\/string>/s', $row['report'], $hostname );
	preg_match('/<key>ManifestName<\/key>.*?<string>(.*?)<\/string>/s', $row['report'], $manifest );

	if ($udmanifest) {
		preg_match('/<key>ManifestName<\/key>.*?<string>(.*?)<\/string>/s', $row['report'], $manifest );
		if ($udmanifest == $manifest[1]) {
			preg_match('/<key>ManifestName<\/key>.*?<string>(.*?)<\/string>/s', $row['report'], $manifest );
			echo "<tr>";
			echo "<td>" . $hostname[1] . "</td>";
			echo "<td> <a href=\"?udmanifest=" . $manifest[1] . "\">" . $manifest[1] . "</a></td>";
			echo "</tr>";
		}else{
		}

	} else {
	echo "<tr>";
	echo "<td>" . $hostname[1] . "</td>";
	echo "<td> <a href=\"?udmanifest=" . $manifest[1] . "\">" . $manifest[1] . "</a></td>";
	echo "</tr>";
	}
}
?>