[dsnowdon]

// get categorys names
$sql_cat_name = "SELECT name,order FROM category ORDER BY order";
$result_cat_name = mysqli_query($con,$sql_cat_name);

while($row_cat_name = mysqli_fetch_array($result_cat_name))
{
	// echo the category main part
	echo '<li '.$category[$row_cat_name["order"]].' ><a class="set" href="index.php?id='.$category[$row_cat_name["order"]].'>'.$result_cat_name["name"].'</a>';
	
	echo '<ul>';
	
	// echo each row in the category
	
	echo '</ul></li>';
}

for some reason this does not work for multiple rows can anyone help me

This post has been edited by Dormilich: 26 March 2013 - 03:05 AM

[Dormilich]

where does the variable $category come from?

and if you loop, then you only have the values $row_cat_name["order"] and $row_cat_name["name"] (not($result_cat_name["name"])) available.

[dsnowdon]

the category variable works i know that, i forgot to include the code.

[andrewsw]

ORDER BY order

Does there not seem something wrong with this statement?! order is a reserved word so you should preferably rename this field or (in MySql) surround both occurrences with back-ticks `.

If you turn on all error reporting you should receive at least one error for this.

error_reporting(E_ALL);
ini_set('display_errors', '1');