Вывод данных из таблицы, которая связана с другой внешним ключом (Страница 1 из 2)

// В первом цикле проходим часы.
for ($hour = 9; $hour <= 18; $hour++) {
  print $hour;
  // Во втором цикле проходим минуты.
  for ($min = 0; $min < 60; $min += 20) {
    print $min;
  }
}

echo '<a href="?db=insert&time=' . urlencode('10:20') . '">10:20</a>';

if (isset($_GET['db'], $_GET['time']) && $_GET['db'] == 'insert') {
  $sql = 'INSERT ...';
}

$start ='16.05.2011' ;
$finish = '20.05.2011';
 $days = array(
0=>'Воскресенье',
1=>'Понедельник',
2=>'Вторник',
3=>'Среда',
4=>'Четверг',
5=>'Пятница',
6=>'Суббота',
);
 $start = explode('.', $start);
$start = mktime(0, 0, 0, $start[1], $start[0], $start[2]);
$finish = explode('.', $finish);
$finish = mktime(0, 0, 0, $finish[1], $finish[0], $finish[2]);
for($t=$start; $t<=$finish; $t+=86400){
                                  $date = date('d.m.Y', $t);//число
                                  $day = date('w', $t);//день недели
                                  echo  "< td>".$days[$day]++. $date++."<br></td>";
                                 }

<TABLE WIDTH="70%" BORDER="5" align=center CELLPADDING="2" CELLSPACING="2" BGCOLOR=#7fc7ff >
<tr BGCOLOR=#6495ed align=center>
<?php  
            $t=16; //начало недели
$pn=date("d.m.Y", mktime(0, 0, 0, 5, $t, 2011));
 $vt=date("d.m.Y", mktime(0, 0, 0, 5, $t+1, 2011));
$sr=date("d.m.Y", mktime(0, 0, 0, 5, $t+2, 2011));
 $cht=date("d.m.Y", mktime(0, 0, 0, 5, $t+3, 2011));
$pt=date("d.m.Y", mktime(0, 0, 0, 5, $t+4, 2011));          
?>
<td>ФИО доктора </td>
<td>Понедельник  <?php  echo"<br>";  echo $pn;?> </td>
<td>Вторник  <?php  echo"<br>";  echo $vt;?></td>
<td>Среда  <?php  echo"<br>";  echo $sr;?></td>
<td>Четверг <?php  echo"<br>";  echo $cht;?></td>
<td>Пятница <?php  echo"<br>";  echo $pt;?></td>
    
<tr   align=center><td  rowspan= 2 valign="top" align=left><?php echo "$PERS_F<br> $PERS_I  

$PERS_O<br> ($JOB_NAME)"?></td>
<td><?php echo " $PERS_PN_S - $PERS_PN_DO"?></td>
<td><?php echo " $PERS_VT_S - $PERS_VT_DO"?></td>
<td><?php echo " $PERS_SR_S - $PERS_SR_DO"?></td>
<td><?php echo " $PERS_CHT_S - $PERS_CHT_DO"?></td>
<td><?php echo " $PERS_PT_S - $PERS_PT_DO"?></td></tr>
 <tr >

<td  valign="top"><table WIDTH="100%" BORDER="1"><?php for ($hour =''.$PERS_PN_S

[0].''+''.$PERS_PN_S[1].''; $hour <= ''.$PERS_PN_DO[0].''+''.$PERS_PN_DO[1].''-1; $hour++) {
 for ($min = '00'; $min < 60; $min += 20) { 
echo '<tr><td align=center BGCOLOR=#94d4dc>
<a href="http://127.0.0.1/write_s.php?db=insert&time=' . urlencode(''.$hour.':'.$min.'') . ' &date=' .urlencode

(''.$pn.''). ' ">'.$hour.':'.$min.'</a>';
}
}?></table></td>

<td  valign="top"><table WIDTH="100%" BORDER="1" ><?php for ($hour =''.$PERS_VT_S

[0].''+''.$PERS_VT_S[1].''; $hour <= ''.$PERS_VT_DO[0].''+''.$PERS_VT_DO[1].''-1; $hour++) {
 for ($min = '00'; $min < 60; $min += 20) { 
echo '<tr><td align=center BGCOLOR=#94d4dc><a href="http://127.0.0.1/write_s.php?db=insert&time=' . 

urlencode(''.$hour.':'.$min.'') . '&date='.urlencode(''.$vt.''). '">'.$hour.':'.$min.'</a>';
}
} 
?></table></td>
<td valign="top"><table WIDTH="100%" BORDER="1"><?php for ($hour =''.$PERS_SR_S

[0].''+''.$PERS_SR_S[1].''; $hour <= ''.$PERS_SR_DO[0].''+''.$PERS_SR_DO[1].''-1; $hour++) {
 for ($min = '00'; $min < 60; $min += 20) { 
echo '<tr><td align=center BGCOLOR=#94d4dc><a href="http://127.0.0.1/write_s.php?db=insert&time=' . 

urlencode(''.$hour.':'.$min.'') 

.'&date='.urlencode(''.$sr.'').'">'.$hour.':'.$min.'</a>';
}
} 
?></table></td>
<td valign="top"><table  WIDTH="100%" BORDER="1"><?php for ($hour =''.$PERS_CHT_S

[0].''+''.$PERS_CHT_S[1].''; $hour <= ''.$PERS_CHT_DO[0].''+''.$PERS_CHT_DO[1].''-1; $hour++) {
 for ($min = '00'; $min < 60; $min += 20) { 
echo '<tr><td align=center BGCOLOR=#94d4dc><a href="http://127.0.0.1/write_s.php?db=insert&time=' . 

urlencode(''.$hour.':'.$min.'') . '&date='.urlencode(''.$cht.'').'">'.$hour.':'.$min.'</a>';
}
} 
?></table></td>
<td  valign="top"><table WIDTH="100%" BORDER="1"><?php for ($hour =''.$PERS_PT_S

[0].''+''.$PERS_PT_S[1].''; $hour <= ''.$PERS_PT_DO[0].''+''.$PERS_PT_DO[1].''-1; $hour++) {
 for ($min = '00'; $min < 60; $min += 20) { 
 echo '<tr><td align=center BGCOLOR=#94d4dc><a href="http://127.0.0.1/write_s.php?db=insert&time=' . 

urlencode(''.$hour.':'.$min.'') .  '&date='.urlencode (''.$pt.'').'">'.$hour.':'.$min.'</a>';
}
} 
</table></td>
</tr>  
 </TABLE>

 $Sootvetsvie ="SELECT * from PRIEM WHERE  PR_DOC='"."$PERS_F"."' AND PR_DATA='".$pn."'";
    $result2 = ibase_query($Sootvetsvie,$link);
    $row2 = ibase_fetch_object($result2);
    $PR_VREMYA = $row2->PR_VREMYA;
              for ($hour =''.$PERS_PN_S[0].''+''.$PERS_PN_S[1].''; 
$hour <= ''.$PERS_PN_DO[0].''+''.$PERS_PN_DO[1].''-1; $hour++) 
{  
 for ($min = '00'; $min < 60; $min += 20) 
{  
  if ($hour<>''.$PR_VREMYA[0].''+''.$PR_VREMYA[1].''or$min<>''.$PR_VREMYA[3].''+''.$PR_VREMYA[4].'')
echo '<tr><td align=center BGCOLOR=#94d4dc> 
<a href="http://127.0.0.1/write_s.php?db=insert&time=' . urlencode(''.$hour.':'.$min.'') . ' &date=' .urlencode(''.$pn.''). ' ">'.$hour.':'.$min.'</a>';
}
}