php问题,自己看的头疼,请高手指点
来源:百度知道 编辑:UC知道 时间:2024/05/09 03:50:57
那位高手指点点,看我我代码那里错了,它老提示while后边那句错了,帮看下,谢谢!
<?php
include("conn.php");
$url=$_SERVER['REQUEST_URI'];
$url=parse_url($url);
$url=$url[path];
$pagesize=5;
$numq=mysql_query("select * from message");
$num=mysql_num_rows($numq);
if ($_GET[page]) {
$pagevle=$_GET[page];
$page=($pagevle-1)*$pagesize;
$page=",";
}
if ($num>$pagesize) {
if ($pagevle>=1) $pagevle=1;
echo "共 $num 条"."<a href=$url?page=".($pagevle-1).">上一页</a>"."<a href=$url?page=".($pagevle+1).">下一页</a>";
}
$sql="select * from message limit $page $pagesize";
$query=mysql_query($sql);
while($row=mysql_fetch_array($query)){
echo "<hr><b>".$row[user]." | ".$row[title]." | ".$row[content];
}
<?php
include("conn.php");
$url=$_SERVER['REQUEST_URI'];
$url=parse_url($url);
$url=$url[path];
$pagesize=5;
$numq=mysql_query("select * from message");
$num=mysql_num_rows($numq);
if ($_GET[page]) {
$pagevle=$_GET[page];
$page=($pagevle-1)*$pagesize;
$page=",";
}
if ($num>$pagesize) {
if ($pagevle>=1) $pagevle=1;
echo "共 $num 条"."<a href=$url?page=".($pagevle-1).">上一页</a>"."<a href=$url?page=".($pagevle+1).">下一页</a>";
}
$sql="select * from message limit $page $pagesize";
$query=mysql_query($sql);
while($row=mysql_fetch_array($query)){
echo "<hr><b>".$row[user]." | ".$row[title]." | ".$row[content];
}
while那句没有,是它前面的这一句有错:
$sql="select * from message limit $page $pagesize";
应该修改为:
$sql="select * from message limit $page,$pagesize";
仔细看,你差一个逗号。
补充:
你下面这样的语句更是错的:
$page=",";
这样SQL语句就是" ... limit , 5",你莫非不知道这是错的吗?
while($row=mysql_fetch_array($query)){
echo "<hr><b>".$row['user']." | ".$row['title']." | ".$row['content'];
}
limit后面要加逗号,
sql语句错了