Есть такой вот код, он должен выводить таблицу с расписанием по выбранному преподавателю, таблицу строит, но пустую. Точно такой же код, но с бд на mysql все прекрасно строит. Помогите разобраться что не так.
$th = mssql_query("select * from timetable1 where name='$_POST[ListBox]' ");
$schedule = array();
$week = array();
$times = array('8.00-9.40','9.55-11.35','12.05-13.45','14.15-15.50','16.00-17.35','17.45-19.20');
$days = array('Пн', 'Вт', 'Ср', 'Чт', 'Пт', 'Сб');
if (mssql_num_rows($th)!=0)
{
if($th)
{
foreach ($times as $time)
{
foreach ($days as $day)
{
$schedule[$day][$time] = ' ';
$week[$day][$time] = '';
}
}
while($teacher = mssql_fetch_assoc($th))
{
if ($teacher['week'] == 'над чертой' && $schedule[$teacher['day']][$teacher['time']] == ' ')
$schedule[$teacher['day']][$teacher['time']] = $teacher['subject'].' '.$teacher['audience'].'<hr />'.$schedule[$teacher['day']][$teacher['time']];
elseif ($teacher['week'] == 'под чертой' && $schedule[$teacher['day']][$teacher['time']] != ' ')
$schedule[$teacher['day']][$teacher['time']] .= $teacher['subject'].' '.$teacher['audience'];
elseif ($teacher['week'] == 'под чертой' && $schedule[$teacher['day']][$teacher['time']] == ' ')
$schedule[$teacher['day']][$teacher['time']] .= '<hr />'.$teacher['subject'].' '.$teacher['audience'];
elseif ($teacher['week'] == 'над чертой' && $schedule[$teacher['day']][$teacher['time']] != ' ')
$schedule[$teacher['day']][$teacher['time']] = $teacher['subject'].' '.$teacher['audience'].$schedule[$teacher['day']][$teacher['time']];
elseif ($teacher['week'] == 'все время')
$schedule[$teacher['day']][$teacher['time']] = $teacher['subject'].' '.$teacher['audience'];
$week[$teacher['day']][$teacher['time']] .= $teacher['week'];
}
echo "<table border=1>";
echo "<tr align='center'><td></td><td>Пн</td><td>Вт</td><td&g t;Ср</td><td>Чт</td><td>Пт</td><td>Сб</td></tr>" ;
foreach ($times as $time)
{
echo "<tr align='center'><td>".$time."</td>";
foreach ($days as $day)
{
echo "<td width='100' height='50' valign='middle' align='center'>";
echo $schedule[$day][$time];
echo "</td>";
}
echo "</tr>";
}
echo "</table>";
}
else
{
echo "<p><b>Error: ".mssql_error()."</b><p>";
}
}
else
{
echo "<br> Данных по выбранному преподавателю нет.";
}