如果你想取得50条记录后的10记录。select * from yourTable limit 50,10;
$sql="select * from yourTable where id>22 order by id limit 10,1"; $rs=mysql_db_query($dbname,$sql); $row=mysql_fetch_array($rs); echo $row[id];我这么写,比如当前记录id为22,那么我取22后面第10个的值 结果 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
$sql="select * from yourTable where id>22 order by id limit 10,1";这条SQL语句有错误,没写你的表名?
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
$rs=mysql_db_query($dbname,$sql);
$row=mysql_fetch_array($rs);
echo $row[id];我这么写,比如当前记录id为22,那么我取22后面第10个的值
结果
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
$sql="select * from yourTable where id>22 order by id limit 10,1";这条SQL语句有错误,没写你的表名?