Untitled

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<META HTTP-EQUIV=Content-Type CONTENT="text/html; charset=windows-1250">
<link rel="stylesheet" type="text/css" href="http://www.lesy.sk/css/page.css">
<link rel="stylesheet" type="text/css" href="http://www.lesy.sk/css/lesy.css">
<script language="JavaScript" src="http://www.lesy.sk/scripts/lesy.jsp"></script>
       <title>Zoznam známych vlastníkov lesných pozemkov</title>
<?php
die("Konec");
$spojenie = mssql_connect("SRV-DB001\SHAREPOINT", "portalGR", "Lsradmin00" );
mssql_select_db("intranet_public", $spojenie);
?>
</head>
<body leftmargin=20 topmargin=20 rightmargin=20>
<div width=790 valign=middle border=0 cellpadding=0 cellspacing=0>
<h1>Výsledky vyhľadávania pre <?php php echo $_POST["rc"]; ?></h1>
<?php

$dotaz = mssql_query("SELECT RCI, VLA, CLV, KRAT, OKRES, NAZOV, NAZOVOZ, LINKOZ FROM vlastnici_view where RCI like '".$_POST["rc"]."' order by okres, nazov",$spojenie);
if (mssql_num_rows($dotaz)>0):
?>
<p>
<table valign="middle" width="780"  border=0 cellspacing="0">
<tr class=class="zoznamth">
<td width="150" bgcolor="#CCCCCC" class="zoznamth"><div align="center">Odštepný závod</div></td>
<td width="320" bgcolor="#CCCCCC" class="zoznamth"><div align="center">Vlastník</div></td>
<td width="80" bgcolor="#CCCCCC" class="zoznamth"><div align="center">Číslo LV</div></td>
<td width="80" bgcolor="#CCCCCC" class="zoznamth"><div align="center">Počet LV</div></td>
<td width="50" bgcolor="#CCCCCC" class="zoznamth"><div align="center">Okres</div></td>
<td width="150" bgcolor="#CCCCCC" class="zoznamth"><div align="center">Katastrálne územie</div></td>
</tr>
<?php
while ($zaznam = mssql_fetch_array($dotaz)):
?>
<tr height=30 onmouseover=highlight(this,1) onmouseout=highlight(this,0)>
<td class="zoznam1" align="center"><a href='<?php echo $zaznam["LINKOZ"]; ?>' target=_blank><?php echo $zaznam["NAZOVOZ"]; ?></a></td>
<td class="zoznam1"><?php echo $zaznam["VLA"]; ?></td>
<td class="zoznam1" align="center"><?php echo $zaznam["CLV"]; ?></td>
<td class="zoznam1" align="center"><?php echo $zaznam["KRAT"]; ?></td>
<td class="zoznam1" align="center"><?php echo $zaznam["OKRES"]; ?></td>
<td class="zoznam1"><?php php echo $zaznam["NAZOV"]; ?></td>
</tr>
<?php
endwhile;
?>
</table>
</p>
<?php
else: echo "<p>V databáze vlastníkov neexistuje identifikátor, ktorý ste zadali.</p>";
endif;
$sesion_id = session_id();
$dotaz2 = mssql_query("INSERT INTO vlastnici_log VALUES ('".$_POST["rc"]."', '".$sesion_id."', getdate())",$spojenie);
mssql_close($spojenie);
?>

</div>
</body>
</html>