Question

php新手 本来想弄个分页但是下面的sql语句好像执行不了总是报错

$sqls = "select * from content order by id asc limit ($pageID-1)*$PageSize,$PageSize";
显示出来的sql语句//$sqls = "select * from content order by id asc limit (3 - 1)*10,10";
错误信息Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\APMServ5.2.6\www\htdocs\mykey\index.php on line 35 貌似是返回结果有问题
求高手解释一下

Answer 1

语法不对，$sqls = "select * from content order by id asc limit ".($pageID-1)*$PageSize.",".$PageSize; 这样就行了

Answer 2

在双引号中的字符串不会计算，可改为如下
$sqls = "select * from content order by id asc limit ".($pageID-1)*$PageSize.",$PageSize";

Answer 3

检查 content表示否在对应的数据库中,或者content表示否实际存在.

Answer 4

双引号里不能运算