- $ret = '<div id="menu">
- <ul id="nav">
- <li><a href="./">Start</a></li>
- <li><a href="./?mask=personal">Personal</a></li>
- <li><a href="./?mask=overview_gewaesser">Gewässer</a></li>
- <li><a href="#">Abfragen</a></li>
- </ul>
-</div>
-';
+ $ret = '<div id="menu">';
+ $ret .= '<ul id="nav">';
+ $ret .= '<li><a href="./">Start</a></li>';
+
+ $sql = "SELECT id,name FROM sys_menu ORDER BY priority";
+ $sth = pg_query($sql);
+
+ if ($sth)
+ while ($row = pg_fetch_assoc($sth))
+ $ret .= sprintf('<li><a href="./?menu=%d">%s</a></li>', $row['id'], $row['name']);
+
+ $ret .= '</ul>';
+ $ret .= '</div>';
+