Retrieve an image based on mysql_insert_id in its name

[Jankie]

Hi and wish all moderators and members are doing well i
Back with a question after a long while,hope to find the valuable typical support from thescripts people and members.

My host does not offer foreign key feature on tables,so what I did is stick the corresponding submission id in the member's uploaded file when renaming the file.

Each member can upload up to 6 files.

Now,I'm clueless how to retrieve those matching images(or just 1 image) based on the corresponding mysq_insert_id in the image name.

Needless to say I would be extremely grateful to the person(s) who can share me the way(if any) to do it.

Many thanks in advance.


The relevant pieces of code below:


[php]
include 'Con.inc.php';

$sql = "INSERT INTO members (member_id,firs tname,lastname, category,title, message) VALUES ('$member_id',' $firstname','$l astname','$cate gory','$title', '$message')";

$member_id=mysq l_insert_id();
$newfilename = $original_name. $filename[$x].$member_id.'.' .$filename[$x+1];

$sql = "INSERT INTO images (imagename,imag etype,imagesize ,image_data) VALUES ('$newfilename' ,'$imagetype',' $imagesize','$i mage_data')";
[/php]

As you can see the images are in a second table(1member=6 images)

[ak1dnar]

Hi there,
You should add the member id with each image record in the in your image table. then you can use MySQL "joins" to retrieve them easily.

members table
<1001> <name>
<1002> <name>

images table
<1> <image_records> <1001>
<2> <image_records> <1001>
<3> <image_records> <1001>
..........
..........
<7> <image_records> <1002>

[Jankie]

Thank you so much ajaxrand !