entering data into two tables? HELP

[hammersm]

I have two tables, one with the colums
UserID , Email (UserID is autoincrementing(
the other with
UserID , Phone

I have a form that posts the email address and the phone to my handling page. So how do I write a query that enters the email address in the first table then gets the autoincremented UserID. Then enters the Phone in the other table with the same UserID that has just been created by the first INSERT query.

I have been trying to do this for ages with no luck.

If anyone can help I would be very happy,

Cheers

Mark

[trq]

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]I have been trying to do this for ages with no luck.
[/quote]
Post your code.

[ober]

You cannot do that all in one query.

INSERT INTO table1 (col1, col2) VALUES (val1, val2)
run query
$new_id = mysql_insert_id($result);

INSERT INTO table2 (col1, col2) VALUES ($new_id, val2)
run query