Click to See Complete Forum and Search --> : inserting multiple rows?


abs0lut
05-02-2008, 06:34 PM
http://img291.imageshack.us/img291/1879/39061130pv1.th.jpg (http://img291.imageshack.us/my.php?image=39061130pv1.jpg)
database structure
ctable
http://img236.imageshack.us/img236/4026/ctableiy5.th.jpg (http://img236.imageshack.us/my.php?image=ctableiy5.jpg)
iqtable
http://img236.imageshack.us/img236/7027/iqtablevd1.th.jpg (http://img236.imageshack.us/my.php?image=iqtablevd1.jpg)

Quantity and names are stored in database iqtable,
usb, usb cable and avr have different iqids,
I want to insert iqid with their cost..
example if you enter a cost in the name usb, the computer will get the iqid of the name and insert them together with the cost you entered..
how will I get the iqid of the quantity and names??
please help me..

Phill Pafford
05-16-2008, 02:40 PM
http://dev.mysql.com/doc/refman/5.0/en/insert.html