$sql = "select distinct fb_babrand,fb_bacode,fb_bamodel from tblb_battery where fclasscode='1' order by fb_babrand limit '100'"; $sql = "select distinct fb_babrand,fb_bacode,fb_bamodel from tblb_battery where fclasscode='1' order by fb_babrand limit '200'";这两句都可以,为什么前面的就不行?
$offset=1; $pagesize=100; $sql = "select distinct fb_babrand,fb_bacode,fb_bamodel from tblb_battery where fclasscode='1' order by fb_babrand limit $offset,$pagesize";这样也不行哪?why?
$sql = "select distinct fb_babrand,fb_bacode,fb_bamodel from tblb_battery where fclasscode='1' order by fb_babrand limit '200'";这两句都可以,为什么前面的就不行?
$pagesize=100;
$sql = "select distinct fb_babrand,fb_bacode,fb_bamodel from tblb_battery where fclasscode='1' order by fb_babrand limit $offset,$pagesize";这样也不行哪?why?
OFFSET是关键字,不是让你用个php变量