<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<style type="text/css">
<!--
BODY
{scrollbar-face-color: #0B6BCC; scrollbar-darkshadow-color: #0B6BCC;
scrollbar-shadow-color: #0000CC; scrollbar-highlight-color: #0B6BCC; scrollbar-3dlight-color: #0000CC;
scrollbar-track-color: #FFFFFF; scrollbar-arrow-color: #FFFFFF; }
-->
</style>
<script language="JavaScript">
<!--
var thetimer = null;
var e = " Список нормативных документов"
function showtime() {
DaysOfWeek = new Array(7);
DaysOfWeek[0] = "Воскресенье";
DaysOfWeek[1] = "Понедельник";
DaysOfWeek[2] = "Вторник";
DaysOfWeek[3] = "Среда";
DaysOfWeek[4] = "Четверг";
DaysOfWeek[5] = "Пятница";
DaysOfWeek[6] = "Суббота";
Months = new Array(12);
Months[0] = "Январь";
Months[1] = "Февраль";
Months[2] = "Март";
Months[3] = "Апрель";
Months[4] = "Май";
Months[5] = "Июнь";
Months[6] = "Июль";
Months[7] = "Август";
Months[8] = "Сентябрь";
Months[9] = "Октябрь";
Months[10] = "Ноябрь";
Months[11] = "Декабрь";
var now = new Date();
var year = now.getYear();
if (year < 2000)
year += 1900;
var mins = ((now.getMinutes() < 10) ? ":0" : ":") + now.getMinutes();
var secs = ((now.getSeconds() < 10) ? ":0" : ":") + now.getSeconds();
window.status = " " + DaysOfWeek[now.getDay()] + " " + Months[now.getMonth()] + " " + now.getDate() + ", " + year + " " + now.getHours() + mins + secs + e;
thetimer = setTimeout("showtime()",1000);
}
//-->
</script>
</head>
<body background="back.gif" onLoad="showtime()">
<?
//error_reporting(0);
$servername='Dboc-server';
//$servername='localhost';
//$servername='Microsoft SQL Server';
$databasename='oit';
$username='user55';
$password='444';
$link = mssql_connect ($servername, $username, $password)
or die ("Ошибка при подключении к серверу");
//$servername, $username,$password)
mssql_select_db($databasename);
$sql="
select
POZNUM,POZNAME,DOC_TIP,RAZRAB,IZM_NUM,PRIKAZ_NUM,PRIKAZ_DATE,PRIKAZ_SROK
from UK_NDMain
ORDER BY POZNUM ";
$res = mssql_query($sql);
if(!$res)
{
echo "<p>Ошибка в условии</p>";
}
$num=mssql_num_rows($res);//
for($i=0; $i<$num; $i=$i+1)
{
$data=mssql_fetch_array($res);
?>
<table border="1" cellpadding="0" cellspacing="0" bordercolor="#000000" summary="0" rules="cols" width="2100">
<tr>
<td width="100" ><? echo $data[POZNUM]; ?></td>
<td width="250" ><? echo $data[POZNAME]; ?></td>
<td width="125" ><? echo $data[DOC_TIP]; ?></td>
<td width="140" ><? echo $data[RAZRAB]; ?></td>
<td width="20" ><? echo $data[IZM_NUM]; ?></td>
<td width="100" ><? echo $data[PRIKAZ_NUM]; ?></td>
<td width="100" ><? echo $data[PRIKAZ_DATE] ; ?></td>
<td width="100" ><? set dateformat ymd; echo $data[PRIKAZ_SROK];?></td>
</tr>
</table>
<?
//break;
}
?>
<?
mssql_close($link);
?>
</body>
</html>
Вот короче весь текст!!! Придумайте чёнибудь плизззз!! У меня никак не получается
