為什么limit查詢報(bào)錯(cuò)語(yǔ)法錯(cuò)誤?
//此行報(bào)錯(cuò):syntax?error,?unexpected?'",3"'?語(yǔ)法錯(cuò)誤。 $sql?=?"SELECT?*?FROM?message?limit".($page-1)*3.",3"; //然后加兩個(gè)變量,再寫成$sql?=?"SELECT?*?FROM?message?limit?$page_from,$page_size";就沒問題了 $res?=?$conn->query($sql); while($abc?=?$res->fetch_assoc()){ $rows[]?=?$abc; }
<table?border="1"?style="text-align:center;?width:200px;"> <tr> <th>內(nèi)容</th> </tr> <?php?foreach?($rows?as?$abc):??> <tr> <td><?php?echo?$abc['mes'];??></td> </tr> <?php?endforeach??> </table>
2019-08-13
$sql
?=?
"SELECT?*?FROM?message?limit"
.(
$page
-1)*3.
",3"
;這里的limit后面應(yīng)該要有空格
$sql
?=?
"SELECT?*?FROM?message?limit "
.(
$page
-1)*3.
",3"
;