That theory made sence all the way. Thank you for that TimeBomb. As for my imaganation I tried to make these tables and try to understand your theory.
The following is the menu table:
CREATE TABLE `pages` (
`parentId` varchar(10) DEFAULT NULL,
`parentName` varchar(230) DEFAULT NULL,
`isMenu` varchar(2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
And than I need to make the php code but I do not know where to start and how to link the table `menu` above to the table `pages` below:
CREATE TABLE `pages` (
`id` int(4) unsigned NOT NULL AUTO_INCREMENT,
`time` varchar(10) DEFAULT NULL,
`lastby` varchar(2) DEFAULT NULL,
`order_id` varchar(2) DEFAULT NULL,
`text` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;