為什么limit查詢報錯語法錯誤？
//此行報錯：syntax?error,?unexpected?'",3"'?語法錯誤。
$sql?=?"SELECT?*?FROM?message?limit".($page-1)*3.",3";
//然后加兩個變量，再寫成$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>內容</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后面應該要有空格$sql?=?"SELECT?*?FROM?message?limit ".($page-1)*3.",3";