This is the code
$query = mysql_query("SELECT avatar FROM users WHERE UserID = ".$userID."");
$row = mysql_fetch_array($query);
$user_avatar = trim($row['avatar']);
unlink($user_avatar);
but for some reason i get this error Warning:unlink();
why $user_avatar returns empty ? and if i echo it shows t_cabbbccebbfhdb.jpg
unlink remove files whereas unset is for variables.
If the variable returns empty, perhaps the query does not return any records. Did you try to run the query manually?