<?

$db = mysql_connect("localhost","root","");
mysql_select_db("ias");

$result = mysql_query("SELECT * FROM `table`",$db);
$myrow = mysql_fetch_array($result);
 ?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
    <table border="1" cellspacing="0" width="100%" bgcolor="#e6eeee">
        <tr>
        <td rowspan="2" class="head" align="center">№</td>
        <td colspan="4" class="head" align="center">Навигация</td>
        <td colspan="2" class="head" align="center">Фамилия</td>
        <td colspan="2" rowspan="2" class="head" align="center">Имя</td>
        <td colspan="2" rowspan="2" class="head" align="center">Отчество</td>
        <td colspan="2" rowspan="2" class="head" align="center">Дата рождения</td>
        <td colspan="2" class="head" align="center">Национальность</td>
        <td colspan="2" class="head" align="center">Пол</td>
        <td colspan="2" rowspan="2" class="head" align="center">Личный телефон</td> 
        <td colspan="2" rowspan="2" class="head" align="center">Хобби, увлечения</td>
        <td colspan="2" rowspan="2" class="head" align="center">Льготная категория</td>
        <td colspan="2" rowspan="2" class="head" align="center">Награды, звания</td>
        </tr>
      
        <tr>
        <td colspan="2" align="center"><input type='checkbox' name='sel_all' onChange='for (i in this.form.elements) this.form.elements[i].checked = this.checked'></td>
        <td colspan="2" align="center">Изменить</td> 
        <td colspan="2" align="center">Фамилия</td>
        <td colspan="2" align="center">Национальность</td>
        <td colspan="2" align="center">Пол</td>    
        </tr>
       <tr> 


<?
$w=1;
do
 {
 ?>
	   <tr>
        <td colspan=1><?=$w; echo "."; $w++?></td>
        <td colspan=2><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $myrow['id']; ?>"></td> 
        <td colspan=2></td>
        <td colspan=2><?=$myrow['surname']?></td>
        <td colspan=2><?=$myrow['name']?></td>
        <td colspan=2><?=$myrow['fname']?></td>
        <td colspan=2><?=$myrow['birthday']?></td>
        <td colspan=2><?=$myrow['nation']?></td>
        <td colspan=2><?=$myrow['sex']?></td>
        <td colspan=2><?=$myrow['cfn']?></td>
        <td colspan=2><?=$myrow['hobby']?></td>
        <td colspan=2><?=$myrow['lgota']?></td>
        <td colspan=2><?=$myrow['award']?></td> 
        </tr>
      <? }
	  
	  while($myrow = mysql_fetch_array($result));?>
<tr>
<td colspan="25" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>

<?php

// Check if delete button active, start this 
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}
// if successful redirect to delete_multiple.php 
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>

</table>
</form>
</td>
</tr>
</table>