sql語(yǔ)句出錯(cuò)問(wèn)題
關(guān)于sql語(yǔ)句出錯(cuò)的問(wèn)題,是因?yàn)槊總€(gè)sql語(yǔ)句里的代碼都需要用空格隔開(kāi),不然就會(huì)出錯(cuò),不顯示數(shù)據(jù),代碼應(yīng)該是這樣, $sql="select * from page LIMIT " .($page-1) * 10 . ", 10 ";
關(guān)于sql語(yǔ)句出錯(cuò)的問(wèn)題,是因?yàn)槊總€(gè)sql語(yǔ)句里的代碼都需要用空格隔開(kāi),不然就會(huì)出錯(cuò),不顯示數(shù)據(jù),代碼應(yīng)該是這樣, $sql="select * from page LIMIT " .($page-1) * 10 . ", 10 ";
2016-06-23
舉報(bào)
2016-07-08
只要limit后面加個(gè)空格,再接" 就沒(méi)問(wèn)題
2016-06-24
把一句換成了兩句就可以了,如下:
$current = ($page - 1) * 10;
$sql = "SELECT * FROM pagination LIMIT $current,10";