Erasing elements with SQL DELETE WHERE

[jimmyslam]

Im triying to erase a row with this code.

[code] $id=$_GET['id'];
echo "#".$id." ";
$temp = intval($id);

$sql="DELETE * FROM news WHERE ID = $temp";
mysql_query ($sql);
[/code]

Why is not erasing? the ID table nad everything exists i dont get any error mensage either.

If I edit it works with this:
[code]$ID=$_GET['ID'];
$date=$_POST['Year']."-".$_POST['Month']."-".$_POST['Day'];
$description=$_POST['text'];
$linkN=$_POST['linkN'];
$linkURL=$_POST['linkURL'];

$sql = "UPDATE news SET date = '$date', description = '$description', linkN = '$linkN', linkURL = '$linkURL' WHERE ID = '$ID'";

mysql_query ($sql);
echo("UPDATED!!!");[/code]


If i try like this:
[code] $id=$_GET['id'];
echo "#".$id." ";
$temp = intval($id);

$sql="DELETE * FROM news WHERE ID = '$id'";
mysql_query ($sql);


echo ("ERASED");[/code]
it doesnt work either.

:-S :-\

[fenway]

Drop the "*"... should be "DELETE FROM...".

[jimmyslam]

thanks it worked :) :D