[NanoEntity]

PHP Code:


CREATE TABLE menu (
   id int(3) NOT NULL auto_increment,
   linkid varchar(255) NOT NULL,
   linktitle text NOT NULL,
   link text NOT NULL,
   PRIMARY KEY (id)
);


function menu() { 
global $DB_site;

$link=$DB_site->query("SELECT * FROM menu WHERE id ORDER BY linkid ASC");
while ($row = mysql_fetch_array($link)) { 
$output = "$row[linkid]"; 
$output .= "<a href=\"$row[link]?link=$row[id]\">".stripslashes($row[linktitle])."</a><br>"; 
} 
return $output; 
} 


OK this only lists 1 link with 1 linkid menu

what I want is to have unlimited linktitles under assigned linkid menu

so I can have any number of menus with assiged links to it.

Any Idea how to code it useing the DB?