PHP/MySQL int auto_increment Issue

[DJDOG]

I’m trying to think of the best way to do this and maybe someone could help me out. (Stuck)

I currently have 2 tables named;

Config and Streams

Config:
id int(11) No auto_increment

On new creation of profile it automatically sets a new id.

Stream:
id int(11) No auto_increment

On new creation of stream it creates a new id, but to match it with the profile I use gid.

gid text latin1_swedish_ci No

I’m trying to figure out how to get id from config and set it in streams of gid.

I could simply 'add hidden input box' and put id in it...but maybe there be a better way of doing this. Trying to make this as secure as I can.

[gordonrp]

Hard to understand what you are saying.

But:
If you are trying to insert data into two tables, you can set the first table to have an auto increment id column.

Then use http://php.net/manual/en/function.mysql-insert-id.php to grab the ID number for the insert.

Then insert into the next table with a reference to the mysql_insert_id from the the last table.