Have an account? Sign in
Login  Register  Facebook
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);
Started: September 18, 2011 Latest Activity: September 18, 2011 form php mysql
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
In: September 18, 2011

I need the HTML form
September 18, 2011

yes html form fo select what?
September 18, 2011

Your Answer

xDo you want to answer this question? Please login or create an account to post your answer