Page 1 of 1

sql and php question!

Posted: Thu Nov 28, 2002 2:00 am
by ampersand
Hi!
I'm a newbie to this so maybe someone here could help me.

I have two tables: CD and SW,
In my form I fill out the CD Title and SW Title, but I need to let the cd.cd_id be inserted into sw.cd_id, how do I do that? I read something about using a 0 in the insert statement was the same as auto increment, but that won't do..

Hope you'll understand what I'm trying to say here :) :)

Posted: Thu Nov 28, 2002 2:50 am
by twigletmac
I've moved this to databases because it's a SQL question rather than a PHP one.

What does your SQL statement currently look like?

Mac

Posted: Thu Nov 28, 2002 7:43 am
by ampersand
thanks, but I have figured it out, but I'm not sure what I did :) :)

Thanks anyway!