---
title: "loop"
type: "forum-thread"
url: "https://www.webforum.nu/amne/php/52204-loop"
topic: "PHP"
topic_url: "https://www.webforum.nu/amne/php"
author: "aleborg"
published: "2002-09-04T15:14:45.000Z"
updated: "2002-09-04T15:14:45.000Z"
replies: 0
views: 206
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/php/52204-loop"
---

# loop

## #1 — aleborg, 2002-09-04T15:14Z

Jag har en loop som ser ut så här:

```php
Function Get_Categories($cat){
	global $dbname, $dbhost, $dbuser, $dbpass;
	$conn = mysql_connect($dbhost, $dbuser, $dbpass);
	mysql_select_db($dbname, $conn);
	$query = "Select CatID, Cat_Name From Ads_categories Where Cat_Group='$cat' Order By Cat_Name";
	$result = mysql_query($query, $conn); 
	return $result;
	mysql_close ();
}
Function Get_Cat(){
	global $dbname, $dbhost, $dbuser, $dbpass;
	$conn = mysql_connect($dbhost, $dbuser, $dbpass);
	mysql_select_db($dbname, $conn);
	$query = "Select Distinct(Cat_Group) From Ads_categories Group By Cat_Group Order By Cat_Group";
	$result = mysql_query($query, $conn); 
	return $result;
	mysql_close ();
}

        $SITE_NAME = $sitename;
		$myArr1 = Get_Cat();
		For ($i=0; $row1 = mysql_fetch_array($myArr1); $i++)
		{
		  //här kommer vi åt namn genom
				$table_rows[] = array( 'CATEGORY_NAME' => $row1[0],
									 );
		
				$myArr = Get_Categories($row1[0]);
				For ($j=0; $row = mysql_fetch_array($myArr); $j++)
				{
				  //här kommer vi åt namn genom
						$caten[] = array( 'CATEGORIES' => $row[1],
										  'CATEGORY_URL' => "adlist.php?category=".$row[0],
											 );
				}
		}
        $tpl = new template;
        $tpl->load_file('complete', 'templates/index.htm');
        $tpl->parse_loop('complete', 'caten');
        $tpl->parse_loop('complete', 'table_rows');
        $tpl->pprint('complete', array('SITE_NAME'));
```

 

Meningen är att det ska visas så här:
Kategori 1
\--sub1-1
\--sub1-2
Kategori 2
\--sub2-1
\--sub2-2

Men det visas:
Kategori 1
\--sub1-1
\--sub1-2
\--sub2-1
\--sub2-2
Kategori 2
\--sub2-1
\--sub2-2
\--sub1-1
\--sub1-2

Vad har jag missat?

Permalänk: https://www.webforum.nu/p/52204

---

Tråden på webben: https://www.webforum.nu/amne/php/52204-loop