老師,我想問一下
$sql = "select * from imooc_admin limit ".($page-1) * 2 .",2 ";
//把SQL語句傳送數據中
$result = mysql_query($sql);
//處理數據
while ($row = mysql_fetch_assoc($result)){
??? echo $row['id']. '-'. $row['username']. '-'. $row['email']. "<br>";
}
報錯誤:Warning: ?mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\APMServ5.2.6\www\htdocs\shopImooc\admin\test.php on line 24
但是改成$sql = "select * from imooc_admin " 可以顯示表中所有內容,為什么呢?
2015-08-12
$sql = "select * from imooc_admin limit ".($page-1) * 2 .",2 ";改成下面兩行就正確了
$sql = "select * from imooc_admin limit ".($page-1) * 2;
$sql.=?",2 ";
2018-06-19
非常感謝