Deleting a file

[jcstanley]

Hi

I currently have a php script which allows a user to do the following:
A title
A description
Upload a picture.

The picture gets stored in a folder called /pictures

The mysql table has the following fields:
title
description
picture

The link to a picture gets stored in the picture field (eg. /pictures/image1.jpg)

This all works fine until it comes to deleting.  The delete query will delete the entry in the table, but obviously not the actual uploaded picture in the /pictures folder.  

Eventually the /pictures folder will get full of images that are no longer used.

Is there anyway these pictures can be deleted at the same time as the data in the database?

Thanks

[Gruzin]

Try something like this:

[code]$sql = mysql_query("SELECT * FROM archives WHERE date='$id'");
while($row = mysql_fetch_array($sql)){
$file = "uploads/".$row['link'];
unlink($file);
}
$del = mysql_query("DELETE FROM archives WHERE date='$id'");[/code]

Regards,
George

[jcstanley]

Thank You

That works perfectly  :)