PHP Loop Problem

programming
1

i am trying to get the loop to output the data in my DB, via XML.

<?php 

include 'connect.php'; 
$category = $_GET['category'];

$xml_output = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>
"; 
$xml_output .= "<gallery>
";  

	$query = "SELECT * FROM galleryImg WHERE category='$category'"; 
	$result = mysql_query($query) or die("Data not found."); 
	
	$perPage = 6;
	$count = mysql_num_rows($result); // COUNTS IMAGES (1,2,3, ... 13) 
	$pageTotal = ($count / $perPage); // CALCULATES PAGES
	
for($x = 0 ; $x < ceil($pageTotal); $x++){ 
	$xml_output .= "	<x>
"; 

	for($i = 0 ; $i < $perPage; $i++){ 
		$row = mysql_fetch_assoc($result);
		
		$xml_output .= "		<image id=\"".$row['id']."\">
";
		$xml_output .= "			 <name>".$row['title']."</name>
";
		$xml_output .= "			 <thumb>images/thumbs/".$row['image']."</thumb>
";
		$xml_output .= "		</image>
";
	}
	$xml_output .= "	</x>
";
} 
$xml_output .= "</gallery>";  

echo $xml_output; 
?>

this is what it Displays:

<gallery>
	<x>
		<image id="1">
			 <name>image 1</name>
                         <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="2">
			 <name>image 2</name>
			 <thumb>images/thumbs/adl57.jpg</thumb>
		</image>
		<image id="3">
                         <name>Spaceous Bathroom</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="4">
			 <name>Spanish Style Bathroom</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>

		<image id="5">
			 <name>Stylish Basin</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="6">
			 <name>White Bathroom</name>
			 <thumb>images/thumbs/adl57.jpg</thumb>
                </image>
	</x>
	<x>
		<image id="7">
			 <name>Modern Bathroom</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="8">

			 <name>Before Queens</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="9">
			 <name>After Queens</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>

		<image id="10">
			 <name>test</name>
			 <thumb>images/thumbs/adl57.jpg</thumb>
		</image>
		<image id="11">
			 <name>test</name>
			 <thumb>images/thumbs/adl57.jpg</thumb>

		</image>
		<image id="12">
			 <name>test</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
	</x>
	<x>
		<image id="13">
                         <name>test</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="">
			 <name></name>
			 <thumb>images/thumbs/</thumb>
		</image>

		<image id="">
			 <name></name>
			 <thumb>images/thumbs/</thumb>
		</image>
		<image id="">
			 <name></name>
			 <thumb>images/thumbs/</thumb>
		</image>

		<image id="">
			 <name></name>
			 <thumb>images/thumbs/</thumb>
		</image>
		<image id="">
			 <name></name>
			 <thumb>images/thumbs/</thumb>
		</image>

	</x>
</gallery>

This is what i am aiming for:

<gallery>
	<x>
		<image id="1">
			 <name>image 1</name>
                         <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="2">
			 <name>image 2</name>
			 <thumb>images/thumbs/adl57.jpg</thumb>
		</image>
		<image id="3">
                         <name>Spaceous Bathroom</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="4">
			 <name>Spanish Style Bathroom</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>

		<image id="5">
			 <name>Stylish Basin</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="6">
			 <name>White Bathroom</name>
			 <thumb>images/thumbs/adl57.jpg</thumb>
                </image>
	</x>
	<x>
		<image id="7">
			 <name>Modern Bathroom</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="8">
                         <name>Before Queens</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
		<image id="9">
			 <name>After Queens</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>

		<image id="10">
			 <name>test</name>
			 <thumb>images/thumbs/adl57.jpg</thumb>
		</image>
		<image id="11">
			 <name>test</name>
			 <thumb>images/thumbs/adl57.jpg</thumb>
                </image>
		<image id="12">
			 <name>test</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
	</x>
	<x>
		<image id="13">
                         <name>test</name>
			 <thumb>images/thumbs/adl09.jpg</thumb>
		</image>
	</x>
</gallery>

HELP ME PLEASE!!