<?

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

$result = mysql_query("SELECT * FROM `table` WHERE 1",$db);
$myrow = mysql_fetch_array($result);
 



?>

        <table border="1" cellspacing="0" width="100%" bgcolor="#e6eeee">
        <tr>
        <td>№</td>
       
        <td>Фамилия</td>
        <td>Имя</td>
        <td>Отчество</td>
        <td>Дата рождения</td>
        <td>Национальность</td>
        <td>Пол</td>
        <td>Личный телефон</td> 
        <td>Хобби, увлечения</td>
        <td>Льготная категория</td>
        <td>Награды, звания</td>
        </tr>
      
        
      
<?
$i=1;
while ($myrow = mysql_fetch_array($result))
 {
?>  
	   <tr>
        <td><?=$i; $i++?></td>       
        <td><?=$myrow['surname']?></td>
        <td><?=$myrow['name']?></td>
        <td><?=$myrow['fname']?></td>
        <td><?=$myrow['birthday']?></td>
        <td><?=$myrow['nation']?></td>
        <td><?=$myrow['sex']?></td>
       <td><?=$myrow['cfn']?></td>
        <td><?=$myrow['hobby']?></td>
        <td><?=$myrow['lgota']?></td>
        <td><?=$myrow['award']?></td> 
        </tr>
      <? }?>

       
 </tr>

        <table>