[Resolved] Unlink(); and input from db.

[benson]

Hey,
Just simple one 😃 (i hope)

I want too know why this is just not working.

include 'includes/db.php';
$nick = $_SESSION['nick'];
$pad = mysql_query("SELECT avat_pad FROM users WHERE nicknaam='$nick'");
unlink($pad);
$avat = "avat_pad=".$avat_pad.",";

He says
Warning: unlink(Resource id #6): No such file or directory in /home/virtual/site15/fst/var/www/html/profiel.php on line 314
Unknown column 'images' in 'field list'

How is that possible ?

[njm]

Well, normally you would use unlink to delete a file, by passing the filename as the argument. You seem to be passing it a Resource ID instead.

hth, njm

[benson]

but what can i do about it ??

[leatherback]

$result = mysql_query("SELECT avat_pad FROM users WHERE nicknaam='$nick'");
while($pad = mysql_fetch_array($result)
{
unlink($pad[avat_pad]);
}

[benson]

thnx for that one 😃

But now i have to create an dynamic sql.
i have this:

	$nick = $_SESSION['nick'];
	if($unlinking == "1")
		{
		include 'includes/db.php';
		$result = mysql_query("SELECT avat_pad FROM users WHERE nicknaam='$nick'"); 
		while($pad = mysql_fetch_array($result)) 
		{ 
		unlink($pad['avat_pad']); 
		}
		$avat = " avat_pad='".$avat_pad."' ";
		}
	else
		{
		$avat = "";
		}
//other sh*t
$sql = mysql_query("UPDATE users SET voornaam='$voornaam', achternaam='$achternaam', woonplaats='$woonplaats', geb_datum='$geb_datum', info_auto='$info_auto', email_adres='$emailadres', website='$website',".$avat."paswoord='$db_password',  cookie='$cookie' WHERE nicknaam='$nick' ")or die(mysql_error());

But the query is incorrect.

[leatherback]

Hey,

what does this do:
".$avat."

J.

PS: Perhaps an idea to add some enters to your query, which would make reading a bit more easy?

[benson]

The $avat is the dynamic piece.
look at the piece of code above it.
There it's being told (gedefineerd)

[leatherback]

Have you echood the query so you can see what is actually passed to the database?

J.