connecting image paths with products

[jakebur01]

Hello,

 

I have a table of products that I am attempting to connect image paths with. I am going to create a new column in my table for image paths. The folder that contains the images contains images whose names match the product no.      Ex.    384-842      whould match      384-842.jpg

 

What would be the best way to do this automatically? I need someone to step me through it.

 

like this?

 

while($myrow=mysql_fetch_array($result))
{
$pattern="(".$myrow['mls_num'].")"; 
if ($handle = opendir('../images')) {
   while (false !== ($file = readdir($handle))) {
   if(eregi($pattern, $file)) 
   {
       $image_link='http://www.mydomain.net/images/'.$file.'';
    break;
    }
   }
   closedir($handle);
}

[jakebur01]

bump...