<?php

If (isset($_POST['see_btn'])){

    $type=$_POST['type'];
    $spec=$_POST['spec'];
    $date=$_POST['date'];

    If ((!empty($type))and(!empty($date))and(!empty($spec))){
            $myServer = "sql-206"; $myUser = "std-21";   $myPass = "dssp4371";  $myDB = "std-21";
            $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");
            $selected = mssql_select_db($myDB, $dbhandle) or die("Couldn't open database $myDB");
            mssql_query("SET NAMES 'utf8'",$myDB);

         if ($type=='Женские специалисты'){
             //выполняем запросы
            $query = ("SELECT female_info.female_id,female_date,female_time,female_spec,female_name, female_phone, female_mail, female_condition
FROM female_info
INNER JOIN female_main ON  female_info.female_id=female_main.female_id
INNER JOIN female_conditions ON female_conditions.female_id=female_info.female_id
WHERE female_date='$date' and female_spec='$spec'");
            $result1 = mssql_query($query)
                or die('A error 111 occured: ' . mysql_error());

             $o = '<table id="myTable" border="1">

                <thead>
                <tr>
                <th>ID</th>
                <th>Время</th>
                <th>Имя</th>
                <th>Телефон</th>
                <th>Электронная почта</th>
                <th>Дополнительные пожелания</th>
                </tr>
                </thead><tbody>';

               while ( $record = mssql_fetch_array($result1) )
          {
              $o .= '<tr><td>'
                      .$record ['female_id']
                      .'</td><td>'
                      .$record ['female_time']
                      .'</td><td>'
                      .$record ['female_name']
                      .'</td><td>'
                      .$record ['female_phone']
                      .'</td><td>'
                      .$record ['female_mail']
                      .'</td><td>'
                      .$record ['female_condition']
                      .'</td></tr>';
          }
                $o .= '</tbody></table>';

                echo $o;


         }else if($type=='Мужские специалисты'){
             //вызываем хранимые процедуры
             $query = ("SELECT male_info.male_id,male_date,male_time, male_spec,male_name, male_phone, male_mail, male_condition
FROM male_info
INNER JOIN male_main ON  male_info.male_id=male_main.male_id
INNER JOIN male_conditions ON male_conditions.male_id=male_info.male_id
WHERE male_date='$date' and male_spec='$spec'");
            $result1 = mssql_query($query)
                or die('A error occured: ' . mysql_error());

             $o = '<table id="myTable" border="1">

                <thead>
                <tr>
                <th>ID</th>
                <th>Время</th>
                <th>Имя</th>
                <th>Телефон</th>
                <th>Электронная почта</th>
                <th>Дополнительные пожелания</th>
                </tr>
                </thead><tbody>';

               while ( $record = mssql_fetch_array($result1) )
          {
              $o .= '<tr><td>'
                      .$record ['male_id']
                      .'</td><td>'
                      .$record ['male_time']
                      .'</td><td>'
                      .$record ['male_name']
                      .'</td><td>'
                      .$record ['male_phone']
                      .'</td><td>'
                      .$record ['male_mail']
                      .'</td><td>'
                      .$record ['male_condition']
                      .'</td></tr>';
          }
                $o .= '</tbody></table>';

                echo $o;
         }
    }else{
                echo"<div class='err'>Обнаружены пустые поля!</div>";
            }
}
?>