[PHP] RE: Maybe a stupid question but can it be done?

2002-09-24 Thread Tim Ward
the ID field in the first table can be an auto-increment field and the second table needs to have an ID INT field that is not auto increment. Insert into the first table, use mysql_insert_id() (or whatever it is) to get the auto incremented value and then do your second insert using that value fo

[PHP] Re: Maybe a stupid question but can it be done?

2002-09-23 Thread Remon Redika
I just run two insert to do that. with two different sql syntax ... Chuck PUP Payne writes: > Ok, Let's try this again, for some reason this didn't post from early today. > > I have db that has two tables that I am needing to post the same information > into both tables, I can't use ID. S