adding new user to DB

[Anon]

I am trying to get a new user_id from one table and enter it into another table. ie.

The form first INSERTS the client info into the clients table. The id column automatically creates a unique id by having auto increment set and unique set to the ID column.

clients table
- id

Here's my problem... How do I get that last 'id' value to pass to the next form for the username and password? ( INSERT INTO user_pass SET user='$userVal', pass='$passVal', id='$THIS_IS_THE_ID_JUST_INSERTED'; )

user_pass table
- id (generated from last INSERT).

Thanks in advance for any help!

By the way i'm using PHP 4 and MySQL, just in case there might be any built in functions that I could use for this purpose.

[amcgrath]

Don't you mean:
insert into user_pass
(user,pass,id)
values('$userVal','$passVal',$THIS_IS_THE_ID_JUST_INSERTED') ????

[Anon]

Actually no. I'm using MySQL and that's the way I've always done it with MySQL. Does that SQL syntax work with MySQL? If it does than it would probably be a better way of doing it since it would be more portable.

I figured a way to get the ID.

I'm using mysql_insert_id() and writing that to a session variable. Then I have it available for the next table INSERT.

It works but I'm sure that there is a better way.