Hej eksperten.dk, prøver at få lavet en dropdown menu, fra mysql... Men kan ikke lige finde ud af det. Håber i vil hjælpe...

echo "<div id=\"navigation\">";
echo "<ul class='subjects'>";
// mine subjects / overskrifter.
$subject_nav = mysql_query("SELECT `id`, `subject_name` FROM `icms_subjects` AND active = '1'");
if(!$subject_nav){
die("Database fejl, subject_nav" . mysql_error());
}

while($subject_row = mysql_fetch_array($subject_nav)){
echo "<li><a href=\"index.php?side=$subject_row[id]\">{$subject_row[subject_name]}</a></li>";


// mine sider / pages .
$pages_nav = mysql_query("SELECT `id`, `page_name`, `subject_id` FROM `icms_pages` where subject_id = '{$subject_row[id]}' AND active = '1'");
if(!$pages_nav){
die("Database fejl, pages_nav" . mysql_error());
}

while($pages_row = mysql_fetch_array($pages_nav)){
echo "<ul class='pages'>";
echo "<li><a href=\"index.php?side=$pages_row[id]\">{$pages_row[page_name]}</a></li>";


}
echo "</ul>"; // ul.pages
}
echo "</ul>"; // ul.subjects
echo "</div>



// Subjects table:
CREATE TABLE IF NOT EXISTS `icms_subjects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subject_name` varchar(150) NOT NULL,
`position` int(3) NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3




// Pages table:
CREATE TABLE IF NOT EXISTS `icms_pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subject_id` int(11) NOT NULL,
`page_name` varchar(100) NOT NULL,
`position` int(3) NOT NULL,
`title` varchar(150) NOT NULL,
`target` varchar(150) NOT NULL,
`alias` varchar(150) NOT NULL,
`active` tinyint(1) NOT NULL,
`content` longtext NOT NULL,
`headline` varchar(150) NOT NULL DEFAULT 'venter p&aring; overskrift.',
`lastupdate` varchar(50) NOT NULL DEFAULT 'venter p&aring; at blive opdateret.',
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4

subject_id = den bruger det id som kommer fra den overskrift som pages skal ligge under..


// Style Navigation:

#navigation { width: 150px; padding: 1em 2em; color: #D4E6F4; background: #8D0D19; }
#navigation a { color: #D4E6F4; text-decoration: none; }
ul.subjects { padding-left: 0; list-style: none; }
ul.pages { padding-left: 2em; list-style: square; }