在我文章管理页不能从数据库正确获取数据!还有不能删除。
删除文章的代码段:
<?php
//初始化数据库连接
require_once('../connect.php');
$id=$_GET['id'];
$deletesql = "delete * from article where id='$id'";
if(mysql_query( $deletetesql)){
echo "<script>alert('删除文章成功');window.location.href='article_manage.php';</script>";
}else{
echo "<script>alert('删除失败');window.location.href='article_manage.php';</script>";
}?>
管理文章的代码(部分):
<?php
require_once('../connect.php');
$sql = "select * from article order by dateline desc";
$query = mysql_query($sql);
if($query && mysql_num_rows($query)){
while($row =mysql_fetch_assoc($query)){
$data[] = $row;
}
}else{
$data[] = array();
}?>