comparing row[] to filename in directory

[kilbey1]

What function can I use to compare the name listed in a DB row, to a filename listed in a directory?

IE, the row is named picture. The picture in question might be named bad_dog.gif when it was uploaded. I added it to the database field 'picture' when uploaded. Now, upon deletion, I want to clear that image out of the directory. If it's named 'bad_dog.gif' in that row, then I need to find 'bad_dog.gif' in directory 'inventory' (or perhaps multiple directories).

if ($HTTP_POST_VARS[Submit]) { // if user submitted, then delete product from inventory

$query = "SELECT picture FROM products WHERE product_id=$pid"; 
$result = mysql_query ($query); 

//$file = $row[0];

while ($row = mysql_fetch_array($result)) {
	//print "Value stored at that position is $row[0]<BR>"; 
	if (file_exists($file_dir)) { 
		//unlink("$file"); 
		echo $result;
		print "File DIR"; } 
	if (file_exists($thumbs_dir)) { 
		//unlink("$file"); 
		echo $userfile_name;
		print "Thumbs DIR"; }
	else { echo "Nothing"; } 

}

[diego25]

I think your file_exists should be checking for the file, not just the directory. So try

if (file_exists($file_dir . $file)) {

Note that if your $file_dir does not end with a slash, then you'll have to add it in between. Same thing with your $thumbs_dir.

Diego

[kilbey1]

Looks good; my echos came back like I wanted them to. Does this look feasible, where default.gif would never get deleted (since it's the default image in the directory where no other image exists)? I'm mainly concerned that the unlink statement will work the way I'm wanting it to, when I uncomment it.

	while ($row = mysql_fetch_array($result)) {

if (file_exists($file_dir . "/" . $row[picture])) { 
	//print "Directory and File: $file_dir"."/"."$row[picture]<BR>";
	if ($row[picture] != "default.gif") {
		//unlink("$file_dir"."/"."$row[picture]"); 
		echo "Image Deleted<BR>";
	} else { echo "Nothing"; } 
 } 

if (file_exists($thumbs_dir . "/" . $row[picture])) { 
	//print "Directory and File: $thumbs_dir"."/"."$row[picture]<BR>"; 

	if ($row[picture] != "default.gif") {
		//unlink("$thumbs_dir"."/"."$row[picture]"); 
		echo "Image Deleted<BR>";
	} else { echo "Nothing"; } 

} 	

}

Thanks,
Eve