unlink() function not working...

viajero5

When I try to delete a file i get this error:

Warning: unlink(): No such file or directory in /home/.diddle/studiocommunity/studiocommunity.net/deleteart.php on line 17

here is the script deleteart.php:

<? include('header.php'); ?>
<tr>
<td height="400" colspan="3" class="color">
<?
	session_start();

include ('dbconnect.php');

  $conn = db_connect();
  $db = @mysql_select_db ("studiocommunity", $conn)
          or die ("Registration failure, try again.");


$sql = "SELECT * FROM user_art WHERE id=" . $_REQUEST["id"] . ""; 

$myFile = $row['path'];
	unlink("$myFile");


 $sql = "DELETE FROM user_art WHERE id=" . $_REQUEST["id"] . ""; 


if ($result = mysql_query($sql)) { 
echo "Art Deleted!";
};

?>

what is wrong?

viajero5

it also deletes the data in the DB, it just isnt deleting the actual file on the server.

devinemke

viajero5 wrote:
what is wrong?

the error is telling you precisely what is wrong.

the broader point here is that you are never running your SELECT query and then never setting the $row variable.

viajero5

oh gosh, thank you.

viajero5

its giving me the same error..

here is the revised part of the script:

	$select = "SELECT * FROM user_art WHERE id=" . $_REQUEST["id"] . "";
	$result = mysql_query($select);

$myFile = $row['path'];
	unlink("$myFile");

devinemke

re-read my post above...particularly the bit about not setting the $row variable

samudasu

What you really need to do is read about mysql functions and look at the examples in the php manual since it seems you're not clear on them. http://www.php.net/manual/en/function.mysql-fetch-assoc.php You're missing a line that should look like this:

$row = mysql_fetch_assoc($result);