Display and grouping

[NZ_Kiwis]

I have a category table with I'd, category and parentID

the parent ID is the I'd of another row.

I want to loop though all records in a ul li item and display any rows which had the current ID as its parent ID

It might I 3 or 4 layers deep

Food
Desert
Ice cream
Chocolate

[NZ_Kiwis]

Any ideas? i'm still looking for an answer

[barand]

NZ_Kiwis;11032707 wrote:

Any ideas? i'm still looking for an answer

try something like this

$db = new mysqli(HOST, USERNAME, PASSWORD, DATABASE );

$sql = "SELECT category_id, name, parent FROM category";
$res = $db->query($sql);
$cats = array();
while (list($id, $name, $parent) = $res->fetch_row()) {
    $cats[$parent][] = array($id, $name);
}

$parentCat = 1; // set start category
listCats($parentCat, $cats);

//
// recursive function to list child categories
//
function listCats($id, &$cats, $level=0)
{
    if (isset($cats[$id]))
    foreach ($cats[$id] as $child) {
        $indent = str_repeat('----', $level);
        echo $indent . $child[1] . '<br>';
        listCats($child[0], $cats, $level+1);
    }
}