MySQL INSERT help

wxdqz

New Member
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!
 
Back
Top