TDB Computing

The examples on this page is from a database "shop example". This is a mySQL file and can be downloaded here.

Here is the file:

/* MySQL Data Transfer */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for shopexample -- ---------------------------- DROP TABLE IF EXISTS `shopexample`; CREATE TABLE `shopexample` ( `id` int(11) NOT NULL auto_increment, `label` varchar(40) default NULL, `parent_id` int(11) default NULL, `tooltip` varchar(40) default NULL, `orderby` int(11) default NULL, `URL` varchar(60) default NULL, `visibility` int(11) default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `shopexample` VALUES ('1', 'welcome', '0', 'welcome to our site', '1', '#', '1'); INSERT INTO `shopexample` VALUES ('2', 'about us', '0', 'about us', '2', '#', '1'); INSERT INTO `shopexample` VALUES ('3', 'our terms', '0', 'our terms', '3', '#', '1'); INSERT INTO `shopexample` VALUES ('4', 'our products', '0', 'our products', '4', '#', '1'); INSERT INTO `shopexample` VALUES ('5', 'buy now', '0', 'buy now', '5', '#', '1'); INSERT INTO `shopexample` VALUES ('6', 'shoes', '4', 'shoes', '6', '#', '1'); INSERT INTO `shopexample` VALUES ('7', 'coats', '4', 'coats', '7', '#', '1'); INSERT INTO `shopexample` VALUES ('8', 'scarves', '4', 'scarves', '8', '#', '1'); INSERT INTO `shopexample` VALUES ('9', 'umbrellas', '4', 'umbrellas', '9', '#', '1'); INSERT INTO `shopexample` VALUES ('10', 'black shoes', '6', 'black shoes', '10', '#', '1'); INSERT INTO `shopexample` VALUES ('11', 'brown shoes', '6', 'brown shoes', '11', '#', '1'); INSERT INTO `shopexample` VALUES ('12', 'summer coats', '7', 'summer coats', '12', '#', '1'); INSERT INTO `shopexample` VALUES ('13', 'winter coats', '7', 'winter coats', '13', '#', '1'); INSERT INTO `shopexample` VALUES ('14', 'silk scarves', '8', 'silk scarves', '14', '#', '1'); INSERT INTO `shopexample` VALUES ('15', 'wool scarves', '8', 'wool scarves', '15', '#', '1'); INSERT INTO `shopexample` VALUES ('16', 'patterned scraves', '8', 'patterned scarves', '16', '#', '1'); INSERT INTO `shopexample` VALUES ('17', 'ladies umbrellas', '9', 'ladies umbrellas', '17', '#', '1'); INSERT INTO `shopexample` VALUES ('18', 'gents unmbrellas', '9', 'gents umbrellas', '18', '#', '1');

The actual table contains the following fields

id (unique auto generated key field)
label (for the menu)
parent_id
tooltip
orderby
url (if the link is read from a field rather than a parameter - for this example they are all set to #)
visibility (intereger of eith 0 - not visible - or 1 - visibile).

We have generated 4 from the TDB Blue skin (not wildly aesthetic we agree) but you will see actual menus in action. Be the way, the one on the left with the products is also an example of a dynamic menu.

Please note that TAB and EXPANDED only allow for 2 levels of menu. Vertical and Horizontal allow are any number of levels.

Dreamweaver css menu wizard example