Вот понадобился сабж.<br>На виндовом серваке работает "на ура", а как сделать на никсах - непонятно.<br>Ниже код, работающий на винде.<br><br><?php <br> $Kiev_st = '1.1.5';<br>$Dnepr_st = '1.2.5';<br>
$Don_st = '1.3.5';<br>$Khar_st = '1.6.5';<br>echo "<META http-equiv='Content-Type' content='text/html; charset=windows-1251'>";<br>echo "<table border='1' align='left' bordercolor='#000000'><br>
<tr><br> <td><a href='start.php?Obj=$Kiev_st&Type=1'>Київ</a></td><br> <td><a href='start.php?Obj=$Dnepr_st&Type=1'>Дніпропетровськ</a></td><br>
<td><a href='start.php?Obj=$Don_st&Type=1'>Донецьк</a></td><br> <td><a href='start.php?Obj=$Khar_st&Type=1'>Харків</a></td><br></tr><br>
</table><br></br>";<br> if (StrLen($_GET['Obj']) > 0) $obj_num = $_GET['Obj'];<br>else $obj_num = "<a href="http://1.1.5.1">1.1.5.1</a>"; <br> if (StrLen($_GET['Obj']) > 0) $type = $_GET['Type'];<br>
else $type = "1";<br><br>$db_conn = new COM("ADODB.Connection"); <br>$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./123.mdb").";"; <br>$db_conn->open($connstr); <br>
<br>$rS = $db_conn->execute("SELECT [Obj_Name_Ua],[Obj_Code],[Obj_Info_Ua] FROM [Object] WHERE ([Obj_Code] = '$obj_num')"); <br>$S1 = $rS->Fields(0); <br>$S3 = $rS->Fields(2); <br>while (!$rS->EOF) <br>
{ <br>if ($S3 > "") echo" $S3->value </br>";<br> $rS->MoveNext(); <br>}<br>$rS->Close(); <br>$db_conn->Close(); <br> if (StrLen($_GET['Obj']) > 0) $obj_num = $_GET['Obj'];<br>
else $obj_num = "<a href="http://1.1.5.1">1.1.5.1</a>"; <br> if (StrLen($_GET['Obj']) > 0) $type = $_GET['Type'];<br>else $type = "1";<br>$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./123.mdb").";"; <br>
$db_conn->open($connstr); <br>$rS = $db_conn->execute("SELECT [TASK_UID],[TASK_ID], [TASK_START_DATE], [TASK_FINISH_DATE], [TASK_TYPE], [TASK_COST], [TASK_NAME], [TASK_OUTLINE_NUM] FROM [MSP_TASKS] WHERE (([TASK_OUTLINE_NUM] LIKE '%' + '$obj_num'+'.' + '%')AND([TASK_TYPE]=$type)) ORDER BY [TASK_OUTLINE_NUM]"); <br>
$f1 = $rS->Fields(0); <br>$f2 = $rS->Fields(1); <br>$f3 = $rS->Fields(2); <br>$f4 = $rS->Fields(3); <br>$f5 = $rS->Fields(4); <br>$f6 = $rS->Fields(5); <br>$f7 = $rS->Fields(6); <br>$f8 = $rS->Fields(7); <br>
echo "<table border='1' align='left' bordercolor='#000000'>";<br>echo " <br><tr bgcolor='#55AAFF'><br> <td>Код об'єкту</td><br> <td>Назва</td><br>
<td>Ціна</td><br> <td>Дата початку</td><br> <td>Дата кінця</td><br></tr> ";<br>while (!$rS->EOF) <br>{ <br>echo " <br><tr><br> <td>$f8->value</td><br>
<td><a href='start.php?Obj=$f8->value&Type=0'>$f7->value</a></td><br> <td>$f6->value</td><br> <td>$f3->value</td><br> <td>$f4->value</td><br>
</tr> ";<br> $rS->MoveNext(); <br>} <br>echo "</table>";<br>$rS->Close(); <br>$db_conn->Close(); <br>?> <br><br><br> <br><br clear="all"><br>-- <br>Regards, vitich at gmail dot com<br>