noclist Posted November 18, 2010 Share Posted November 18, 2010 I have a value in one table referenced in another table by foreign key and I'm having trouble wrapping my brain around how to write my insert statement. My table is called Years and each year is represented by a yID, which I then reference in my main table named Titles. I have a user interface inserting records in the database where I would like a year submitted which can assign the correct yiD to it's respective record in table Titles. Could someone explain how I would set this up in an insert statement without having to manually code in each year value and assigning them to php variables? Quote Link to comment https://forums.phpfreaks.com/topic/219120-sql-insert-with-inner-joins/ Share on other sites More sharing options...
fenway Posted November 21, 2010 Share Posted November 21, 2010 Not sure that a year table is appropriate at all. But the "value" of your interface fields should be the yID. Quote Link to comment https://forums.phpfreaks.com/topic/219120-sql-insert-with-inner-joins/#findComment-1137525 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.