Meny-skript

Hej!

Någon som vet hur man gör detta i ASP eller har nått exempel på liknande Asp meny med id, parentid lösning mot MySql?
Tacksam för hjälp eftersom jag kört fast lite, lite klurigt detta... :OO

<?
$show_sub_levels_id = $_GET["show_sub_levels_id"];

$database = "test";
$path = "";
$www_user = "user";
$www_password = "";

mysql_connect("$path","$www_user","$www_password") or die("Temporary error, please try again later. (unable to connect to database)");
mysql_select_db("$database") or die ("Temporary error, please try again later. (unable to select database)");

function getTree($parentId="0", $show_sub_levels_id="", $level="0"){
$query = "SELECT * FROM sektioner WHERE parentId='$parentId' ORDER BY text";
$result = mysql_query($query) or die(mysql_error());
$rows = mysql_NumRows($result);

for($index=0; $index<$rows; $index++){
$id = mysql_result($result,$index,"id");
$text = mysql_result($result,$index,"text");
$url = mysql_result($result,$index,"url");

for($a = 0; $a<$level; $a++){
echo "-";
}

if($url != ""){
echo "<a href=\"$url\">;$text</a><br&nb
sp;/>\n";
}else{
echo "<a href=\"$php_SELF?show_sub_levels_id=$id\">;$text</a><br&nbs
p;/>\n";
}

if($id == $show_sub_levels_id){
if(hasChild("$id")){
getTree("$id", "$show_sub_levels_id", $level+1);
}
}
}
  }

function hasChild($id){
$query = "SELECT * FROM sektioner WHERE parentId='$id'";
$result = mysql_query($query) or die(mysql_error());
$rows = mysql_NumRows($result);

if($rows != 0){
return TRUE;
}else{
return FALSE;
}
}

getTree("0", "$show_sub_levels_id", "0");
?>

och databasen:

CREATE TABLE `sektioner` (
  `id` int(11) NOT NULL auto_increment,
  `parentId` int(11) default NULL,
  `text` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  PRIMARY key (`id`),
  key `parentId` (`parentId`)
) TYPE=MyISAM;

INSERT INTO `sektioner` (`id`,`parentId`,`text`,`url`) VALUES ("1","0","l?nk 1","");
INSERT INTO `sektioner` (`id`,`parentId`,`text`,`url`) VALUES ("2","0","l?nk 2","");
INSERT INTO `sektioner` (`id`,`parentId`,`text`,`url`) VALUES ("3","1","subl?nk 1:1","http://1,1");
INSERT INTO `sektioner` (`id`,`parentId`,`text`,`url`) VALUES ("4","1","subl?nk 1:2","http://1,2");
INSERT INTO `sektioner` (`id`,`parentId`,`text`,`url`) VALUES ("5","2","subl?nk 2","http://2");

Sök på rekursiv här i asp-forumet så skall du hitta det du söker. :)

Tackar, hittade vad jag sökte!