# PHP Loop Problem

**URL:** <https://forum.kirupa.com/t/php-loop-problem/266787>\
**Category:** programming\
**Created:** [July 24, 2008, 11:25am UTC](https://forum.kirupa.com/t/php-loop-problem/266787 "2008-07-24T11:25:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![james182](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@james182](https://forum.kirupa.com/u/james182)\
**Post date:** [July 24, 2008, 11:25am UTC](https://forum.kirupa.com/t/php-loop-problem/266787/1 "2008-07-24T11:25:34Z")

</div>

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

```php
<?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:

```auto
<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:

```auto
<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!!