sql and php question!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ampersand
Forum Commoner
Posts: 54
Joined: Thu Nov 28, 2002 2:00 am
Location: Norway

sql and php question!

Post 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 :) :)
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
ampersand
Forum Commoner
Posts: 54
Joined: Thu Nov 28, 2002 2:00 am
Location: Norway

Post by ampersand »

thanks, but I have figured it out, but I'm not sure what I did :) :)

Thanks anyway!
Post Reply