[sccc2008]

Hello,

im having an issue deleting a file from the server. The situation is that I have a file on the server, and the file name is on a database.

Currently I am using the following script to remove the file, but this isnt working. I think that it might have something to do with the CHMOD 777 command. If anyone knows what im doing wrong, please advise.

PHP Code:

require_once(databaseconnection.php');

$query="SELECT filename FROM photo WHERE VALUE1=VALUE2";

mysql_query($query) or die('Error, query failed');

$result = @mysql_query($query);

$row = mysql_fetch_array($result, MYSQL_BOTH); 





if($row[0]!==NULL)

{

chmod( $row[0], 0777 );

unlink( $row[0] );



header("Location: newpage.htm");



} 

[UnrealEd]

you have an error in your syntax: you forgot to open a quote on the first line:

PHP Code:

require_once('databaseconnection.php'); 

ig you fix this, it might work

UnrealEd

[sccc2008]

oh im just using that as an example, in the real query, it is not like that, but i appreciate the input.

[mab]

Posting code that is changed from the actual code to the point of introducing additional errors, just causes wasted effort and wild goose chases.

If you modify your code for posting, at east have the decency of proof-reading it to insure that it accurately represents the problem that you need help with.

[daveganley]

Does $row[0] contain just the name of the pic?
If so is the pic located in the same directory as the script?
If not it's a file path problem.

Please post your full code and dir structure, if you still need help

Dave