如果以ID为判断,就是用查询第一个和最后一个就是最小和最大了,就是用这个语句 select max(id),min(id) from table_example limit 2;
limit 2 可以不加,因为max和min每个只有一个字段
可能是我没说清楚或者你们没明白我找到了个方法,但是效果不是很好,消耗资源较大 SELECT max( id ) AS mid FROM (SELECT id, title FROM yypic_sellinfo ORDER BY id DESC LIMIT 0 , 30 ) AS tableb获取第一页的ID最大值 SELECT max( id ) AS mid FROM (SELECT id, title FROM yypic_sellinfo ORDER BY id DESC LIMIT 20 , 30 ) AS tableb获取第二页的ID最大值如果用楼上的方法,2次获取的值都是一样的
$query = mysql_query("select id from limit 0,10 order by id asc");while($row = mysql_fetch_object($query)) { //自己在这判断不就可以了 $id = $row->id; }
应该没有了,不要看SQL命令的长度,有时短的还执行时间长。
怎么不能修改。。 上面的sql错了$query = mysql_query("select id from order by id asc limit 0,10");while($row = mysql_fetch_object($query)) { //自己在这判断不就可以了 $id = $row->id; }
select max(id),min(id) from table_example limit 2;
SELECT max( id ) AS mid
FROM (SELECT id, title
FROM yypic_sellinfo
ORDER BY id DESC
LIMIT 0 , 30
) AS tableb获取第一页的ID最大值
SELECT max( id ) AS mid
FROM (SELECT id, title
FROM yypic_sellinfo
ORDER BY id DESC
LIMIT 20 , 30
) AS tableb获取第二页的ID最大值如果用楼上的方法,2次获取的值都是一样的
{
//自己在这判断不就可以了
$id = $row->id;
}
上面的sql错了$query = mysql_query("select id from order by id asc limit 0,10");while($row = mysql_fetch_object($query))
{
//自己在这判断不就可以了
$id = $row->id;
}