I am using mySQL and PHP for my site.
In my mySQL database I have three tables: make, item, and item_make (a table that ties the first two together).
I have an admin form to add to my inventory. The form includes info on the item and the make of the item.
When I insert a new row into item, the item is assigned a new ID, created with auto_increment.
How can I go about automatically inserting this newly created ID into the item_make table along with the info from the form on the make of the item?
Thank you!
In my mySQL database I have three tables: make, item, and item_make (a table that ties the first two together).
I have an admin form to add to my inventory. The form includes info on the item and the make of the item.
When I insert a new row into item, the item is assigned a new ID, created with auto_increment.
How can I go about automatically inserting this newly created ID into the item_make table along with the info from the form on the make of the item?
Thank you!