[PHP] PDO Delete, jw Opcje

[miras]

Witam, mam funkcję, która ma usuwać z bazy pewien rekord.. niestety nie usuwa - co jest nie tak?

[PHP] pobierz, plaintext 
	public function delete_id($id,$type) {
	   if ($type=="facebook") {
           $this->del = $this->pdo->exec("DELETE FROM `facebook` WHERE `id` = '{$id}'");
        } else if ($type=="tv") {
           $this->del = $this->pdo->exec("DELETE FROM tv_paczka` WHERE `id` = '{$id}'");
 	   } else if ($type=="galeria") {
           $this->del = $this->pdo->exec("DELETE FROM `gallery` WHERE `id` = '{$id}'");
 	   }
	   if ($this->del) {
			header("Location: index.php?page=delete&type=".$type);
		}
	}
[PHP] pobierz, plaintext 

[tomxx]

Spróbuj zamienić każdą linijkę z zapytaniem, np.:

[PHP] pobierz, plaintext 
$this->del = $this->pdo->exec("DELETE FROM `facebook` WHERE `id` = '{$id}'");
[PHP] pobierz, plaintext 

na:

[PHP] pobierz, plaintext 
$this->del = $this->pdo->exec("DELETE FROM `facebook` WHERE `id` = '".$id."'");
[PHP] pobierz, plaintext 

[miras]

Nic to nie dało.

[Turson]

[PHP] pobierz, plaintext 
public function delete_id($id,$type){
	if ($type==="facebook") {
		$this->type = "facebook";
	}
	elseif ($type==="tv") {
		$this->type = "tv_paczka";
	}
	elseif ($type==="galeria") {
		$this->type = "gallery";
	}
	$delete = $this->type;
	$stmt = $this->pdo->exec("DELETE FROM ".$delete." WHERE `id` = ".$id."");
	if ($stmt) {
		return true;
	}
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
if($obiekt->delete_id($id,$type)){
	header("Location: index.php?page=delete&type=".$type);
}
[PHP] pobierz, plaintext 

To jest metoda a nie funkcja.

[miras]

Syntax error or access violation: 1064 Something is wrong in your syntax obok '' w linii 1'

w tym miejscu blad:

[PHP] pobierz, plaintext 
$stmt = $this->pdo->exec("DELETE FROM ".$delete." WHERE `id` = ".$id."");
[PHP] pobierz, plaintext 

Ok, poradziłem, dzięki.