unlink to delete multiple files from folder

[ali_p]

I am trying to delete files from a folder on my server using unlink. I know how to delete a single file but in this case i need to delete all files which share a common 'name' . Below is my code

$sql = "SELECT *
FROM photos
WHERE photo_group = '$_POST[name]'";
//execute the sql statement
$result = mysql_query($sql, $conn)or die(mysql_error());
$section = $row['section'];
$photo_group = $row['photo_group'];
$title=$row['title'];
$filename[]=$row['filename'];
$id = $row['id'];

$path = '/srv/www/htdocs/webdev/caspi/photo_uploads/';

$unlink = unlink($path . $filename);
if ($unlink) {$display_block .= "Those files been deleted .";} else {$display_block = "There is a problem ! Unable to delete.";}

Now the sql will bring out more than one record and i want to delete from the server all that it brings out. I tried using [] array but this is not allowed.

Can anyone shed any light onto this please??

Thanks

[devinemke]

$sql = "SELECT * FROM photos WHERE photo_group = '" . $_POST['name'] . "'";
$result = mysql_query($sql, $conn) or die(mysql_error());
if (mysql_num_rows($result))
{
	while ($row = mysql_fetch_assoc($result))
	{
		$unlink = unlink('/srv/www/htdocs/webdev/caspi/photo_uploads/' . $row['filename']);
		if ($unlink) {echo 'delete OK<br>';} else {echo 'delete FAILED<br>';}
	}
}
else {echo 'no records found matching that criteria';}

[ali_p]

Thanks for that . However i'm still getting the same error message when i try to delete

Warning: unlink(/srv/www/htdocs/webdev/caspi/photo_uploads/): Is a directory in /srv/www/htdocs/webdev/caspi/admin/events/insert_delete_event.php on line 31

it doesn't seem to see beyond the folder to the individual files.

[ali_p]

Sorry mike, i retried the code and it does work.
Thats wonderful. Thank you.