function buildCategoryOptions($catId = 0)
{
$sql = "SELECT catId, parentId, catName  FROM ha_shop_cats ORDER BY catId";
$result = mysql_query($sql) or die('Cannot get Product. ' . mysql_error());
$categories = array();
while($row = mysql_fetch_array($result))
{
list($id, $parentId, $name) = $row;

if ($parentId == 0) {
// we create a new array for each top level categories
$categories[$id] = array('name' => $name, 'children' => array());
} else {
// the child categories are put int the parent category's array
$categories[$parentId]['children'][] = array('id' => $id, 'name' => $name);
}
}
// build combo box options
$list = '';
foreach ($categories as $key => $value) {

$name     = @$value['name'];
$children = $value['children'];

$list .= "<optgroup label=\"$name\">";

foreach ($children as $child) {
$list .= "<option value=\"{$child['id']}\"";
if ($child['id'] == $catId) {
$list.= " selected";
}

$list .= ">{$child['name']}</option>rn";
}

$list .= "</optgroup>";
}

return $list;
}
Advertisements