整个代码说有非法词组,直接给出错误的行代码吧 $sql = "select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y年%m月%d日 %T' ) from lo order by id desc limit $offset,$pagesize";//用到了DATE-FORMAT格式化日期格式 $result = mysql_query($sql); $num = mysql_num_rows($result);
~~~~(>_<)~~~~ ,说我的代码有非法词组,现在给出了错误行了,帮忙看看,谢谢
DATE_FORMAT(submit_time, '%Y年%m月%d日 %T' ) 这里能这么用吗? 改为:$sql = "select id,username,sex,qq,email,info,ip,submit_time from lo order by id desc limit $offset,$pagesize";
你这几行代码没有问题,提示什么错误?? 是代码报错?还是mysql语句报错??
$sql = "select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y-%m-%d %T') as date from lo order by id desc limit $offset,$pagesize";
要学会查错,首先你要把sql语句打印出来在mysql里面运行哈
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\myweb\liuyanban\index.php on line 28
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\myweb\liuyanban\index.php on line 28 28行$num = mysql_num_rows($result);
sql语句错了,导致mysql_num_rows()报错。 改为 $sql = "select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y-%m-%d %T') as date from lo order by id desc limit $offset,$pagesize";去掉中文字符,可能是这个原因
你数据库中字段submit_time的datetime格式吗? 还是unix时间戳?
phpmyadmin中执行sqld 返回#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$sql = "select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y-%m-' at line 1
确认你数据库已连接成功。 还有$sql = "select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y年%m月%d日 %T' ) from lo order by id desc limit $offset,$pagesize"; 中各个字段在表中是否存在。 echo $sql; //输出看看。
什么叫无法输出sql???你把$sql = "";这句直接放到phpMyadmin中执行?这这。 在代码中。$sql = "..."; 这句话后面 echo $sql; 然后用这个echo出来的结果执行。或者在phpmyadmin中执行: select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y-%m-%d %T') as date from lo order by id desc limit 0,10;
$sql = "select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y年%m月%d日 %T' ) from lo order by id desc limit $offset,$pagesize";//用到了DATE-FORMAT格式化日期格式
$result = mysql_query($sql);
$num = mysql_num_rows($result);
~~~~(>_<)~~~~ ,说我的代码有非法词组,现在给出了错误行了,帮忙看看,谢谢
改为:$sql = "select id,username,sex,qq,email,info,ip,submit_time from lo order by id desc limit $offset,$pagesize";
是代码报错?还是mysql语句报错??
28行$num = mysql_num_rows($result);
sql语句错了,导致mysql_num_rows()报错。
改为 $sql = "select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y-%m-%d %T') as date from lo order by id desc limit $offset,$pagesize";去掉中文字符,可能是这个原因
还有$sql = "select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y年%m月%d日 %T' ) from lo order by id desc limit $offset,$pagesize"; 中各个字段在表中是否存在。
echo $sql; //输出看看。
2011年10月12日 16:20:49 所以并不存在你们认为的 sql 指令错误应从其他方面找原因,比如语言编码
在代码中。$sql = "...";
这句话后面 echo $sql;
然后用这个echo出来的结果执行。或者在phpmyadmin中执行:
select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y-%m-%d %T') as date from lo order by id desc limit 0,10;