Getting the file name

[g7ibby]

Im uploading files to a server folder using the copy function and putting the file name into mysql after it is uploaded. But I would like to check if the file name exists in the DB before it is uploaded. How can I extract the file name before it is uploaded? Seems the file name is only available as the variable named $fupload_name after it is uploaded.

copy($fupload,"$file_dir/$fupload_name") or die ("Could not copy");

Thanks
G

[batman]

Use if statements. First do the database query to see if the file already exists.

$file = $_POST['file'];
$sql = mysql_query("SELECT * FROM table WHERE file='$file'");
$rows = mysql_num_rows($sql);
if($rows >= '1')
{
echo "Im sorry, you cant upload that file...it already exists!";
}
else
{
copy($fupload,"$file_dir/$fupload_name") or die ("Could not copy");
}

Hope that helps,

[g7ibby]

Perfect
Thanks Batman

Here is the final and it works well.

if (!$project_id) 
{echo $no_id; $halt = 1;}


if ($project_id)  

{$sqla = mysql_query ("SELECT * FROM file_proofs WHERE project_id = '$project_id'",$db);
 $rows = mysql_num_rows($sqla);
 if	($rows >= '1') { echo $bad_project; $halt = 1;}
}

if (!$chk_file)
{$sqlb = mysql_query("SELECT * FROM file_proofs WHERE file_name = '$fupload_name'",$db);
 $rows = mysql_num_rows($sqlb);
 if($rows >= '1') {echo $bad_file; $halt = 1;}
}

if (!$halt) 
{
		if(isset($fupload)) {copy($fupload,"$file_dir/$fupload_name") or die ("Could not copy");}
		$sqlc = "INSERT INTO file_proofs (client_id,project_id,file_name) VALUES ('$client_id','$project_id','$fupload_name')";
		$resultc = mysql_query($sqlc); 
		print ("$finish");
}

THANKS AGAIN
G