I can submit new article and upload picture for that article.
So lets say i submitted a new article with an image. Base on the table below, my new article_id will be 2. Then problem is how the foreign key in image table auto update the article_id = 2. So that the image name auto matches the article_id i newly submitted. How do i do that?
Code:articles table: article_id content 1 xxx image table(stored all the article images): id article_id(foreign key) name 1 1 xyz.jpg