mysql limit 不起作用_这句mysql中为什么limit起不到作用

代码：...........$select1='select............'wherehouses.display=1and(houses.houseidin(selecthouses.houseidfrom(selectinnertable.houseid,ABS(latitude-'.$lat.')aslatvalfr...

代码：...........$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没有起到该有的限制作用？

展开