Jump to content

Archived

This topic is now archived and is closed to further replies.

hammersm

entering data into two tables? HELP

Recommended Posts

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

Share this post


Link to post
Share on other sites
[!--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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.