[davestar057]

Hello Again,

Another quick question to clear up a little murky area in my head.



Because of nomalization we split tables up...and up and up etc..... Then we use FOREIGN KEYS to compare the info and link it etc.......

My question is......you set these foreign keys up in a table the same as you have set it up in the table where it is the Primary (cos every PK is nearly always the FK in another table)....The only thing is you cannot use the AUTO_INCREMENT because this is used for the PK in that field.

SO my question is..........how do you update the value of a FK ?????????? all the other fields would be filled in, and the AUTO_INCREMENT would take place on the PK .... but how would I update the FK?????????????????

I am getting confused with all this stuff.....I REALLY hope somebody can help clear some of this up for me as I am about to smash my head through my monitor! lol

[Vicious]

you can get the PK from the one table via mysql_insert_id($link), and then use it to update the FK in the other table.