delete blog

[rida2]

why this does not delete anything??
<?php
session_start();
if(!isset($_SESSION['usernamea']))
{
header("location:index.php");
}
else
{

$_SESSION['usernamea']=$_SESSION['usernamea'];

$a=$_SESSION['a'];
include("../dbconnection.php");
if(isset($_GET['id']))
{

$id=$_GET['id'];




$result=mysql_query("delete * from blogtable where blogid=$id")
$n=mysql_num_rows($result);
echo "nn".$result;
if($n>0)
{
header("location:blogmoderator.php?del=Y");
}
else
{
header("location:blogmoderator.php?del=N");
}

}
}
?>

[johnj]

...delete * from blogtable where blogid=$id

are you sure that this sql is correct?

[freshnet]

You're also missing the ; from the end of that line, so I'd expect you to get an error somewhere.

[rida2]

Hey thanks for replying guys, but that ";" didn't make any difference. Also I am sure of "delete * from blogtable where blogid=$id

[freshnet]

ok for a delete if you want the number of rows you will need to use $n=mysql_affected_rows($result); . For the query itself, try capturing the error (you can just echo mysql_error()). You also should be using mysqli/PDO instead of mysql. See http://php.net/manual/en/function.mysql-affected-rows.php For more information.