PHP Classes

File: data/SQL_Data_Dump.sql

Recommend this page to a friend!
  Classes of Gobinath Mallaiyan   Cascade Dropdown 3 Levels   data/SQL_Data_Dump.sql   Download  
File: data/SQL_Data_Dump.sql
Role: Auxiliary data
Content type: text/plain
Description: Mysql Schema
Class: Cascade Dropdown 3 Levels
Generate 3 linked select inputs from database data
Author: By
Last change:
Date: 17 years ago
Size: 1,670 bytes
 

Contents

Class file image Download
# DynamicDropDown - SQL Table Dump # version 1.0.0 # http://www.gobinath.com # # Generation Time: May 06, 2005 at 04:14 PM # # Author : gobinath ( gobinathm <at> gmail <dot> com ) # # -------------------------------------------------------- # # Table structure for table `brand` # CREATE TABLE `brand` ( `brand_id` smallint(9) NOT NULL auto_increment, `brand_name` varchar(255) NOT NULL default '', `type_id` smallint(9) NOT NULL default '0', PRIMARY KEY (`brand_id`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # # Dumping data for table `brand` # INSERT INTO `brand` VALUES (1, 'brand 1', 1); INSERT INTO `brand` VALUES (2, 'brand 2', 1); INSERT INTO `brand` VALUES (3, 'brand 3', 2); # -------------------------------------------------------- # # Table structure for table `model` # CREATE TABLE `model` ( `model_id` smallint(9) NOT NULL auto_increment, `model_name` varchar(255) NOT NULL default '', `brand_id` smallint(9) NOT NULL default '0', PRIMARY KEY (`model_id`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # # Dumping data for table `model` # INSERT INTO `model` VALUES (1, 'model 1', 1); INSERT INTO `model` VALUES (2, 'model 2', 2); INSERT INTO `model` VALUES (3, 'model 3', 1); # -------------------------------------------------------- # # Table structure for table `type` # CREATE TABLE `type` ( `type_id` smallint(9) NOT NULL auto_increment, `type_name` varchar(255) NOT NULL default '', PRIMARY KEY (`type_id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; # # Dumping data for table `type` # INSERT INTO `type` VALUES (1, 'Type 1'); INSERT INTO `type` VALUES (2, 'Type 2');