Form And PHP Code To Get Upto 15 Values Into A Normalize DB At Once
Hello guys, pls i need a Form And PHP Code To Get Upto 15 Values Into A Normalize DB At Once
Sample Attached MySQL DB Syntax -- -- Table structure for table `litorder` -- CREATE TABLE IF NOT EXISTS `litorder` ( `order_ID` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Order identification number', `order_Name` varchar(45) NOT NULL COMMENT 'Column holds name of person who placed ordern', `order_Address` varchar(45) NOT NULL COMMENT 'Holds the address of the indivudal who placed order', `order_Date` date NOT NULL COMMENT 'Date of order', `order_Reference` varchar(45) NOT NULL, `order_Naira` double NOT NULL, `order_Dollars` double NOT NULL, PRIMARY KEY (`order_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table which holds basic order details' AUTO_INCREMENT=2 ; -- -- Dumping data for table `litorder` -- INSERT INTO `litorder` (`order_ID`, `order_Name`, `order_Address`, `order_Date`, `order_Reference`, `order_Naira`, `order_Dollars`) VALUES (1, 'Sanyaolu Fisayo', '14 Adegboyega Street Palmgrove Lagos', '2010-05-31', 'DL 001', 85600, 563); -- -------------------------------------------------------- -- -- Table structure for table `orderdetails` -- CREATE TABLE IF NOT EXISTS `orderdetails` ( `detail_ID` int(11) NOT NULL AUTO_INCREMENT, `order_ID` int(10) unsigned NOT NULL, `item_code` varchar(50) NOT NULL, `product` varchar(255) NOT NULL, `quantity` int(20) NOT NULL, `amount` double(20,2) NOT NULL, `price` double(20,2) NOT NULL, PRIMARY KEY (`detail_ID`), KEY `order_ID` (`order_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `orderdetails` -- INSERT INTO `orderdetails` (`detail_ID`, `order_ID`, `item_code`, `product`, `quantity`, `amount`, `price`) VALUES (1, 1, 'DL 001', 'AILMENT & PREVENTION DVD- ENGLISH', 16, 12800.00, 800.00), (2, 1, 'DL 002', 'AILMENT & PREVENTION DVD- HAUSA', 16, 12800.00, 800.00), (4, 1, 'DL 003', 'BEAUTY CD', 60000, 20.00, 3000.00);
1 Answer
what is that mean?
please write me the query Description or you want to select the last 15 row from a specific table? Posted: MacOS 0 of 0 people found this answer helpful. Did you? Yes No I need the HTML form yes html form fo select what? |
© Advanced Web Core. All rights reserved