entering data into two mysql tables

[saberx]

Hello,

Yes, I'm a newbie, and here's my question...

I have two tables in a mysql database.

Table 1 name = manufacturer
Table 2 name = model

Table1 has two fields: manu_id (auto increment), manu.
Table2 has three fields: model_id (auto increment), manu_id, model.

I have a simple input form with two text boxes where I type in the manufacturer and the model.

Using php how do I enter the data into the manufacturer table and the model table and get the manu_id in both tables to match up? 😕

TIA.

[mahers]

mysql_query("INSERT INTO manufacturer (manu_id, manu) VALUES ('NULL','".$_POST['manufacturer']."'");

$last = mysql_insert_id();

mysql_query("INSERT INTO model (model_id,manu_id, model) VALUES ('NULL','".$last."','".$_POST['model']."'");

[saberx]

Thanks mahers! Works great.