$mysql_db=mysql_connect("localhost", "root", "");
mysql_select_db("abc",$mysql_db);
$sql="SELECT * from basic where name like '%$textfield%' or ID like '%$textfield%' or age like '%$textfield%' or birthday like '%$textfield%' or sex like '%$textfield%' or room like '%$textfield%' or room_phone like '%$textfield%' or bp like '%$textfield%' or mobile like '%$textfield%'";
$sql_result=mysql_query($sql);
while($sql_row=mysql_fetch_array($sql_result))
{ //结果
echo $sql_row[name];
echo $sql_row[ID];
echo $sql_row[age];
echo $sql_row[birthday];
echo $sql_row[sex];
echo $sql_row[room];
echo $sql_row[room_phone];
echo $sql_row[bp];
echo $sql_row[mobile];
}