[RESOLVED] How to determine if a file is missing from my server

[Smudly]

When I upload new files, their file name is stored into my database. I have been told that a couple of the file downloads weren't working. Upon further investigation I figured out that the file the person wanted to download was nowhere to be seen in my downloads directory. How can I determine if a file exists in my directory? I assume I can somehow use the location that is stored inside my database (ex: myfile.pdf) and compare that with what's in the folder.

[dagon]

file_exists()

[Smudly]

Thanks for the reply. I tried using file exist to check each row in the table and determine if the file does in fact exist. If it does not, that row will be displayed to the page. If it does exist, nothing will be done. The problem I am having is it is displaying ALL rows to the page.
I've tried changing up the code in various ways but nothing seems to work.

Here is my code. (no errors are displayed either)

$result = mysql_query("SELECT * FROM sheets WHERE active='yes'");

$path = "/uploads/";
echo "<table border='0' cellspacing='0' cellpadding='0'>";
echo "<th>ID</th>
	  <th>Artist</th>
	  <th>Title</th>
	  <th>URL</th>
";
$i = 1;
while($row = mysql_fetch_array($result)){

$url = $row['url'];
$sheet = $path.$url;
if (file_exists($sheet)){
	$artist = "";
	$title = "";
	$sheet = "";
}
else{
	$artist = $row['artist'];
	$title = $row['title'];
	echo "<tr>";
	echo "<td>$i</td>";
	echo "<td>$artist</td>";
	echo "<td>$title</td>";
	echo "<td>$url</td>";
	echo "</tr>";
	$i++;
}

}
echo "</table>";

[dagon]

check the path, remember its the file system not the web path. if you use the absolute path you shouldn't have an issue.

[Smudly]

Fixed. Thanks

It seems that having $path = "/uploads/" was causing the problem.

After changing it to $path = "uploads/", it worked.

Thanks