我觉得表格循环应该用while语句: $conn=mysql_connect("localhost","nobody","");
mysql_select_db("abc",$conn);
$sql="SELECT * from basicdata where name like '%$textfield%' or student_ID like '%$textfield%' or age like '%$textfield%' or birthday like '%$textfield%' or sex like '%$textfield%' or bedroom like '%$textfield%' or bedroom_phone like '%$textfield%' or bp like '%$textfield%' or mobile like '%$textfield%'";
$sql_result=mysql_query($sql);
while ($sql_row=mysql_fetch_array($sql_result))
{ //返回结果
print("<tr>");
print("<td bgcolor=\"#dddddd\">
<a href=\"abc.php3?id=$sql_row[student_ID]\">
$sql_row[name]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[student_ID]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[age]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[birthday]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[sex]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[bedroom]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[bedroom_phone]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[bp]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[mobile]</td>");
print("</tr>");
}
mysql_select_db("abc",$conn);
$sql="SELECT * from basicdata where name like '%$textfield%' or student_ID like '%$textfield%' or age like '%$textfield%' or birthday like '%$textfield%' or sex like '%$textfield%' or bedroom like '%$textfield%' or bedroom_phone like '%$textfield%' or bp like '%$textfield%' or mobile like '%$textfield%'";
$sql_result=mysql_query($sql);
while ($sql_row=mysql_fetch_array($sql_result))
{ //返回结果
print("<tr>");
print("<td bgcolor=\"#dddddd\">
<a href=\"abc.php3?id=$sql_row[student_ID]\">
$sql_row[name]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[student_ID]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[age]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[birthday]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[sex]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[bedroom]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[bedroom_phone]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[bp]</td>");
print("<td bgcolor=\"#dddddd\">$sql_row[mobile]</td>");
print("</tr>");
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货