[RESOLVED] How to delete some image files (variables) related to one variable of a different tab

[fandhie]

First I want to apologize that I’m not good in English and I hope you can understand what kind of help I need here…

Let say, if I have a table of product (ProductTable) as follow :

ProductId
ProductName
ProductImage

When I delete a product, I only need to define a variable pointing to image file, let say $image = “image_directory/image_filename”; then unlink this variable to delete the file image.

How if I have another table of image (ImageTable) related to ProductId as follow:
ProductId
ImageId
ImageFileName

And every product can have more than 1 images related to it.

Can anybody show me the way, when I delete one product, I also can delete all images related to it in one process?

[etully]

Let's assume that you want to delete the product with the ID number 18.

$query = "select ImageFileName from ImageTable where ProductId=18";
$result = mysql_fetch_row($query);
while (list($filename)=mysql_fetch_row($result)) {
unlink("image_directory/".$filename);
}

[fandhie]

etully;10977355 wrote:

Let's assume that you want to delete the product with the ID number 18.

$query = "select ImageFileName from ImageTable where ProductId=18";
$result = mysql_fetch_row($query);
while (list($filename)=mysql_fetch_row($result)) {
unlink("image_directory/".$filename);
}

thanks for the guidance.. but after tried your codes and get some error, I've found the right way like this :

$result = mysql_query("SELECT ImageFileName FROM  ImageTable WHERE  ProductId=18");

while (list($filename)= mysql_fetch_row($result)) {
unlink("image_directory/".$filename);
}

thanks anyway 🙂