I'm inserting an Article into a DB. The fields I'm inserting are Title, Intro, Content, Creation_Date. There is a field in the DB that is the primary key, Article_ID, which is auto-increment.
I insert the article into the DB, and it is assigned the article_id by the DB. I want to use that ID later in my code on the same page. Is there any way to get SQL to return the ID on my Insert statement, or must I do a SELECT ... WHERE statement after I do my insert?