how to sort Categories?

[Darkwoods]

Hi im trying to sort my categories but i can't figure out how to do it so please i need help 

what im basically trying to do is to display the gategories this way:

 

Category name

-title

-title

Category name

-Title

-title 

 

i came so far with the code you can see, but i cant make it loop it just show the first category and its contents but the other categories doesn't show up 

 

<?php
$result = mysql_query("SELECT * FROM cat_foodmenu ",$connect);
while($row = mysql_fetch_array($result))
{
			 $id = $row['id'];
			 $title = $row['title'];
        
        echo '<h1>'. $title . '</h1>'; 
        
	$result = mysql_query("SELECT * FROM food_menu WHERE cat_id='$title' ORDER BY id ASC",$connect);
        while ($row = mysql_fetch_array($result))
        { 
        
        $id = $row['id'];
        $title = $row['title']; 
        $price = $row['price'];
	$info = $row['info'];
                
        echo '<div class="recipe"><span class="name_of_the_recipe">' .$title .'</span>';
	echo '<div class="price">$' . $price .'</div>';
	echo '<div class="recipe_bg"> </div><div class="clear_container"></div></div>';
	echo '<p>(' . $info .')</p><br />';


        }
}

?>

[MadTechie]

your over writing the $results,

change

$result = mysql_query("SELECT * FROM food_menu WHERE cat_id='$title' ORDER BY id ASC",$connect);
while ($row = mysql_fetch_array($result))

 

to

$result2 = mysql_query("SELECT * FROM food_menu WHERE cat_id='$title' ORDER BY id ASC",$connect);
while ($row = mysql_fetch_array($result2))

[jl5501]

Also the other variables in the inner loop will need different names

[Darkwoods]

hhaha thanks man i have been stuck with this over 4 hours thankssssss alot

 

karma