This is sql commands for the two tables in my db. my problem is that i want to insert two queries at the same time. But there is a foreign key lic_id and it is also a auto increment key so how can i add the two queries at the same time.
CREATE TABLE IF NOT EXISTS `transaction_chemicals` (
`lic_id` int(10) NOT NULL,
`trans_chem_id` int(10) NOT NULL AUTO_INCREMENT,
`transaction_type` varchar(10) NOT NULL,
`date` datetime NOT NULL,
`amount` float(10,2) NOT NULL,
PRIMARY KEY (`trans_chem_id`),
KEY `lic_id` (`lic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `lab_inventory_chemical` (
`lab_id` int(10) NOT NULL,
`chemical_code` varchar(10) NOT NULL,
`quantity` decimal(10,2) NOT NULL,
`units` varchar(10) NOT NULL,
`reorder_level` decimal(10,2) NOT NULL,
`lic_id` int(10) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`lic_id`),
KEY `lab_id` (`lab_id`),
KEY `lab_id_2` (`lab_id`),
KEY `chemical_code` (`chemical_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
This is my php code
................................................
$qry_lab_inventory_chemical = "INSERT INTO lab_inventory_chemical
(lab_id, chemical_code, quantity, reorder_level, units)
VALUES ('$lab_id', '$chemical_code', '$quantity', '$reorder_level', '$units') ";
$qry_transaction_chemicals="INSERT INTO transaction_chemicals
(lab_id, chemical_code, quantity, reorder_level, units)
VALUES ('$lab_id', '$chemical_code', '$quantity', '$reorder_level', '$units') ";
$result=mysql_query($qry_lab_inventory_chemical);
$result1=mysql_query($qry_transaction_chemicals);
if (($result !=0) && ($result1!=0))
{
echo "<br><font color=green size=+1 >you have successfully added new chemical ! </font> " ;
}
...........................................
