Heya all.
I've searched for an answer to this question and can't find one.
I need to do some inserts on a database for a site that allows user input.
So, simplified, here's my table structure:
Articles:
artID auto_increment
body
etc.
Authors
AuthID
etc
Link
artID
authID
Here's the question: what's the insert statement that will update the db with a new article and a new author and add the link relationship?
Can I do it in one insert? or do I need 2 or 3 statements?
Thanks for your help!
I've searched for an answer to this question and can't find one.
I need to do some inserts on a database for a site that allows user input.
So, simplified, here's my table structure:
Articles:
artID auto_increment
body
etc.
Authors
AuthID
etc
Link
artID
authID
Here's the question: what's the insert statement that will update the db with a new article and a new author and add the link relationship?
Can I do it in one insert? or do I need 2 or 3 statements?
Thanks for your help!