PHP相关数据库查询语句

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<?php
mysql_close();#关闭库
exit;

#检测数据库表是否存在
$sql="select TableName from Fatheranclass where TableName='$TableName'";
$result=mysql_fetch_row(mysql_query($sql));
if($result){
echo "<script language=javascript>alert('抱歉，该表已存在！');window.location.reload('javascript:history.go(-1)')</script>";
exit();
}
#检测结束

#添加到数据库
$sql="INSERT INTO Fatheranclass(AdminClassName,TableName,Orders,Optional,Description)
VALUES('$AdminClassName','$TableName','$Orders','$Optional','$Description')";
if (!mysql_query($sql,$Frank))
{die('Error: ' . mysql_error());}
echo ("<script language=javascript>alert('添加成功！');window.location.reload('$SourceUrl')</script>"); 
exit();
#添加结束

#删除数据库信息
mysql_query("DELETE FROM Fatheranclass WHERE ID='$ID'");
echo ("<script language=javascript>alert('删除成功！');window.location.reload('$SourceUrl')</script>"); 
exit();
#删除结束

#分页循环代码
$PageSize=15;
$Pagenow=$_REQUEST[page];//获取当前页面的值
if ($Pagenow==""){
$Page1=1;
}else{
$Page1=$Pagenow;
}
$Page=$Page1-1;
$pageint=$Page*$PageSize;
$sql02 = mysql_query("SELECT ID FROM Fatheranclass limit 0,3000");
$rows=mysql_num_rows($sql02);//总记录数
$Counts=$PageSize*$Page;
if ($Counts>$rows){
echo "页面超出";
exit;
}

// 计算日期 datediff(字段,'$d')>=-3
//模糊查询 UserName like '%$keyword%'
$CountPage=ceil($rows/$PageSize);//计算出页面数
$d=date("Y-m-d H:i:s");
$sql01 = mysql_query("SELECT ID,AdminClassName,TableName,Orders,Optional FROM Fatheranclass order by Orders desc,ID ASC limit $pageint,$PageSize");
$ling=1;
while($rs = mysql_fetch_array($sql01)){
echo "内容";
$ling++;
}
?>


共查询<?php echo $rows?>条记录[<a href="?">首页</a>]<?php
for($count=1;$count<=$CountPage;$count++){

echo "[<a href='?page=$count'>",$count,"</a>]";
}
?>[<a href="?page=<?php echo $CountPage?>">尾页</a>]
//分页结束


<?php
//修改数据
mysql_query("UPDATE Fatheranclass SET AdminClassName='$AdminClassName',Orders='$Orders',Description='$Description' where ID='$ID'");
echo ("<script language=javascript>alert('修改成功！');window.location.reload('$SourceUrl')</script>"); 
exit();
?>

<?php
$ID=$_REQUEST[ID];//获取当前页面ID值
//查询语句
$sql="select * from Fatheranclass where ID='$ID'";
$Frank=mysql_query($sql);
while($rs=mysql_fetch_array($Frank)){
$View->AdminClassName=$rs['AdminClassName'];
$View->TableName=$rs['TableName'];
$View->Orders=$rs['Orders'];
$View->Optional=$rs['Optional'];
$View->Description=$rs['Description'];
}
?>