$checkinlist = mysql_query("select * from room where No in($chk_id)") or die (mysql_error());
$num_checkin = mysql_num_rows($checkinlist);
if ($num_checkin > 0){
while ($checkin = mysql_fetch_array($checkinlist)){
$No=$checkin['No'];
$Number=$checkin['number'];
}
}