FROM

  rozklad

INNER JOIN subject

ON rozklad.subject = subject.id

INNER JOIN teacher

ON rozklad.teacher = teacher.id

WHERE

  rozklad.day = ".$day_id."

  AND rozklad.class = ".$ClassID."

ORDER BY

  rozklad.lessonnumber";

              $query_urok_list = mysql_query($sql_urok_list, $conn);

              $urok_count = mysql_num_rows($query_urok_list);

              for($ur = 0; $ur < $urok_count; $ur++)

              {

              $urok_number=mysql_result($query_urok_list,$ur,0);

              $urok_name=mysql_result($query_urok_list,$ur,1);

              $urok_teacher_id=mysql_result($query_urok_list,$ur,2);

              $urok_teacher="".mysql_result($query_urok_list,$ur,3)." ".mysql_result($query_urok_list,$ur,4)." ".mysql_result($query_urok_list,$ur,5);

              echo "".$urok_number.". ".$urok_name." - вчитель: <a href='teacherinf.php?id=".$urok_teacher_id."' >".$urok_teacher."</a><br />";                           

              }

              }

  include "footer.inc.php";

?>

Сторінка galareya.php:

<?php

              include ("header.inc.php");

              ?>

              <div id="container">

<h1 align="center">Фото</h1>

<div id="gallery" >

<?php

$directory = 'gallery';

$allowed_types=array('jpg','jpeg','gif','png');

$file_parts=array();

$ext='';

$title='';

$i=0;

$dir_handle = @opendir($directory) or die("There is an error with your image directory!");

while ($file = readdir($dir_handle))

{

              if($file=='.' || $file == '..') continue;

              $file_parts = explode('.',$file);

              $ext = strtolower(array_pop($file_parts));

              $title = implode('.',$file_parts);

              $title = htmlspecialchars($title);

              $nomargin='';

              if(in_array($ext,$allowed_types))

              {

              if(($i+1)%4==0) $nomargin='nomargin';

              echo '

              <div class="pic '.$nomargin.'" style="background:url('.$directory.'/'.$file.') no-repeat 50% 50%;">