- 积分
- 68
- UID
- 13267
- 阅读权限
- 20
- 注册时间
- 2013-3-6
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 1
|
代码:
...........$select1 = 'select ............
' where houses.display=1 and (houses.houseid in (select houses.houseid from (select innertable.houseid , ABS(latitude - ' . $lat . ') as latval from houses innertable order by latval asc limit 10) limittable) ' .
' or houses.houseid in (select houses.houseid from (select innertable2.houseid , ABS(longitude - ' . $lon . ') as lonval from houses innertable2 order by lonval asc limit 10) limittable2)) ' .
' having distance <= ' . $accurancy .
' order by distance asc ' .
' limit ' . $pagenumber * ($page - 1) . ',' . $pagenumber ;
...................................
主要是limit 10 那里没有起到限制作用,测试了下:limit 100与limit 10 的效果一样的
后面的那句 ' limit ' . $pagenumber * ($page - 1) . ',' . $pagenumber ;就可以起到限制作用
想请教下,哪里出现问题,以致于limit 10没有起到该有的限制作用?
|
|