What is the best way to link an image with a record in mysql

Can someone please tell me how I can link an image to a specific record in my news table.

The news table currently has an id field (auto-increment), a title field, a timestamp field and a content field.

I use a form to insert the news item into the database and would like a specific image linked to each item of news.

I did try adding a column named image and a field on the form so I can put the name of the image to be stored in the database and I used this code to try and display the image but it doesn't work

PHP: Select all

echo "<b>".$code['title']."</b><br>Added on: ".$code['date']."<br>".nl2br($code['content'])."<img src=\"images/".$code['image'].".jpg\"><br><br>\n"; 

If there is a better way can someone please tell me how to do it?

I checked the image name and location and it's in exactly where i put in the code.

Have you any more ideas/approaches I could use?