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

[AdRock]

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?

[ukgeoff]

Your approach is perfectly sound.

Suggest something else wrong in the logic/coding somewhere. Check that the image is being stored where you think it is and that the name of the image in the database is what and where you think it is.

[AdRock]

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?