Nå, jeg måtte weekend på det her!
her er løsningen til mit spørgsmål(!)
-----------------------------------------------
$db_conn = mysql_pconnect($hostname, $user, $password); mysql_select_db($database, $db_conn);
$query = "SELECT id, parent_id, name, FROM 2have_menu ORDER by id";
$result = mysql_query($query, $db_conn) or die(mysql_error());
$num_results = mysql_num_rows($result); //return the number of records (rows) returned from the SELECT query.
//creating the array
for ($i=0; $i < $num_results; $i++){
$row = mysql_fetch_array($result); //grab the next row from the query result, and return it as an associative array
//links
if ($row["parent_id"] == 0){
$menu[$row["id"]][$row["parent_id"]] = $row["name"]; //eks. $menu[1] = nyheder
}
//sublinks
else {
$menu[$row["parent_id"]][$row["id"]] = $row["name"]; //eks. $menu[1][2] = nyheder/oversigt
$count_sublinks = $row["id"]; // last id = highest number!
}
}
//$i first number in array
//$q second number in array
//$x id of div
$x=0;
echo "<div id='divCont'>";
for ($i=0; $i < $count_sublinks * 2; $i++){
if (isset($menu[$i][0])){
echo "<div id='divTop".$x."' class='clTop'><a href='#' onclick='menu(".$x."); return false' onfocus='this.blur()'><img src='pic/foldoutmenu_arrow.gif' name='imgA".$x."' width='12' height='12' alt='' border='0'>";
echo $menu[$i][0]."</a><br>";
echo "<div id='divSub".$x."' class='clSub'>";
for ($q=1; $q < $count_sublinks; $q++){
if (isset($menu[$i][$q])){
echo "<a href='#'>".$menu[$i][$q]."</a><br>";
}
}
echo "</div>";
echo "</div>";
$x++;
}
}
echo "</div>";