我想通过数据库 输出最新更新的前4行数据 这个哪有问题 怎么 老是无限循环 老死机,希望高手们指点 ,谢谢了
<?php
include_once "../php/conn.php";
$result=mysql_query("select * from students");
//id号的个数
$arr=mysql_num_rows($result);
$arr1=mysql_fetch_array($result);
if($arr1){
for($i=$arr;$i>$arr-4 && $i>0;$i--){
while($arr){
echo "<tr>";
echo "<td>$arr1[Class_N]</td>";
echo "<td>$arr1[Course]</td>";
echo "<td>$arr1[TeacherNumber]</td>";
echo "<td>$arr1[Teacher_Name]</td>";
echo "<td>$arr1[Time]</td>";
echo "<td>$arr1[ClassRoom]</td>";
echo "<td>$arr1[Professional]</td>";
echo "<td>$arr1[College]</td>";
echo "</tr>";
}
}
}else{
echo "<tr><td colspan='8' style='color:red'>对不起,没有课表,请与管理员联系...</td></tr>";
} ?>
<?php
include_once "../php/conn.php";
$result=mysql_query("select * from students");
//id号的个数
$arr=mysql_num_rows($result);
$arr1=mysql_fetch_array($result);
if($arr1){
for($i=$arr;$i>$arr-4 && $i>0;$i--){
while($arr){
echo "<tr>";
echo "<td>$arr1[Class_N]</td>";
echo "<td>$arr1[Course]</td>";
echo "<td>$arr1[TeacherNumber]</td>";
echo "<td>$arr1[Teacher_Name]</td>";
echo "<td>$arr1[Time]</td>";
echo "<td>$arr1[ClassRoom]</td>";
echo "<td>$arr1[Professional]</td>";
echo "<td>$arr1[College]</td>";
echo "</tr>";
}
}
}else{
echo "<tr><td colspan='8' style='color:red'>对不起,没有课表,请与管理员联系...</td></tr>";
} ?>
没有索引ID 就创建一个字段 ID,设置为自增$SQL="SELECT * FROM students ORDER BY Id DESC LIMIT 0,4";
$mysql->query($SQL);
while ($Result=$mysql->fetch_assoc()){
print_r($Result);//这里设置输出内容即可.
}
$result = mysql_query("select * from students ORDER BY `id` DESC LIMIT 4"); //id根据你的表结构自己改一下
//id号的个数
if (mysql_num_rows($result) > 0) {
while ($arr = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>$arr1['Class_N']</td>";
echo "<td>$arr1['Course']</td>";
echo "<td>$arr1['TeacherNumber']</td>";
echo "<td>$arr1['Teacher_Name']</td>";
echo "<td>$arr1['Time']</td>";
echo "<td>$arr1['ClassRoom']</td>";
echo "<td>$arr1['Professional']</td>";
echo "<td>$arr1['College']</td>";
echo "</tr>";
}
} else {
echo "<tr><td colspan='8' style='color:red'>对不起,没有课表,请与管理员联系...</td></tr>";
}
include_once "../php/conn.php";
$result=mysql_query("select * from students");
//id号的个数
$arr=mysql_num_rows($result);
$arr1=mysql_fetch_array($result);
if($arr1){
for($i=0;$i<4;$i++){
while($arr){
echo "<tr>";
echo "<td>$arr1[Class_N]</td>";
echo "<td>$arr1[Course]</td>";
echo "<td>$arr1[TeacherNumber]</td>";
echo "<td>$arr1[Teacher_Name]</td>";
echo "<td>$arr1[Time]</td>";
echo "<td>$arr1[ClassRoom]</td>";
echo "<td>$arr1[Professional]</td>";
echo "<td>$arr1[College]</td>";
echo "</tr>";
}
}
}else{
echo "<tr><td colspan='8' style='color:red'>对不起,没有课表,请与管理员联系...</td></tr>";
} ?>
这样?
include_once "../php/conn.php";
$result=mysql_query("select * from students order by id desc");
//id号的个数
$arr1=mysql_fetch_array($result);
if($arr1){
for($i=0;$i<4;$i++){
while($arr){
echo "<tr>";
echo "<td>$arr1[Class_N]</td>";
echo "<td>$arr1[Course]</td>";
echo "<td>$arr1[TeacherNumber]</td>";
echo "<td>$arr1[Teacher_Name]</td>";
echo "<td>$arr1[Time]</td>";
echo "<td>$arr1[ClassRoom]</td>";
echo "<td>$arr1[Professional]</td>";
echo "<td>$arr1[College]</td>";
echo "</tr>";
}
}
}else{
echo "<tr><td colspan='8' style='color:red'>对不起,没有课表,请与管理员联系...</td></tr>";
} ?>