導不出數據庫的數據
<?php
include("conn.php");?
//傳入頁碼
?$page=$_POST[p];
?//設置數據庫編碼格式
?mysql_query("SET NAMES UTF8");
?$sql="SELECT * FROM chengji LIMIT".($page-1)*3 . ",3";
?//把sql語句傳送數據中
?$result=mysql_query($sql);
?echo" <table border=1 cellspacing=0? >";
?echo"<tr><td>學號</td><td>課程號</td><td>課程名</td><td>成績</td><td>學分</td></tr>";
?while($row=mysql_fetch_assoc($result)){
?echo "<tr>";
?echo "<td>{$row['sno']}</td>";
?echo "<td>{$row['cno']}</td>";
?echo "<td>{$row['cname']}</td>";
?echo "<td>{$row['xuefen']}</td>";
?echo "</tr>";
?}
?echo "</table>";
?mysql_free_result($result);
?mysql_close($link);
?$page_banner="<a href='".$_SERVER['PHP_SELF']."?p=".($page-1) ."'>上一頁</a>";
?$page_banner="<a href='".$_SERVER['PHP_SELF']."?p=".($page+1) ."'>下一頁</a>";
?echo $page_banner;
?>
導不出數據庫的數據,請問是為什么呢?謝謝
2017-05-23
先看下有沒有成功連接數據庫再找問題