<?php
$id=$_GET["id"];
include("setari.php");
$cxn = @ConnectToDb($dbServer, $dbUser9, $dbPass9, $dbName9);
$check = mysql_query("SELECT * FROM clienti limit 1")or die(mysql_error());
while($myrow = mysql_fetch_array( $check ))
{
$nume=$myrow[nume];
$companie=$myrow[companie];
$fax=$myrow[fax];
}
$check999 = mysql_query("SELECT * FROM oferte where idoferta='$id' limit 1")or die(mysql_error());
while($mzrow999 = mysql_fetch_array( $check999))
{
$judetlnk=str_replace(" ", "+",$mzrow999["judet"]);
$tranzlnk=str_replace(" ", "+",$mzrow999["tranzactie"]);
if(!trim($mzrow999[suprafata]))
{$suprafata="";}else{$suprafata="<font face=verdana>$mzrow999[suprafata]</font>";}
if(!trim($mzrow999[pret]))
{$pret="";}else{$pret="<font face=verdana>$mzrow999[pret] $mzrow999[moneda]</font>";}
$keywords0=str_replace(" ", ", ", $mzrow999[titlu]);
$keywords1=str_replace(" ", ", ", $mzrow999[tranzactie]);
$keywords2=str_replace(" ", ", ", $mzrow999[judet]);
?>
<html>
<head>
<title><?php echo $mzrow999[titlu];?></title>
<meta name=description content="<?php echo $mzrow999[titlu].": ".$mzrow999[tranzactie].", ".$mzrow999[judet];?>">
<meta name=keywords content="<?php echo $keywords0.", ".$keywords2.", ".$keywords1;?>">
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body>
<div align="center">
<?php include "elements/header.php";?>
<br>
<table border="0" width="900" cellspacing="0" cellpadding="0" bgcolor=#FFFFFF>
<tr>
<td colspan=2 align=left>
<?php echo"<br><font size=5 color=#888888 face=arial> <b><u>".$mzrow999[titlu]."</b></u></font><br> <a href=categ.php?categ=".$judetlnk."><font color=#cc3300 size=2 face=verdana>".$mzrow999["judet"]."</a> > <a href=subcateg.php?subcateg=".$tranzlnk."&categ=".$judetlnk."><font color=#cc3300>
".$mzrow999["tranzactie"]."</a><br><br>";?>
</td>
</tr>
<tr>
<td valign="top" width=450 bgcolor=#f2f2f2>
<br>
<table width=400 align=center border=0 cellpadding=0 cellspacing=0> <tr><td valign=top>
<?php if($mzrow999["poza1"]==da and $mzrow999["poza2"]==da)
{
echo"<img border=1 src=poze/".$mzrow999[idoferta]."_1.jpeg align=center vspace=3><br>";
}?>
<p align=justify><font color=#666666 size=2 face=verdana><?php echo $mzrow999["descriere"];?></p><br><font color=#666666 size=2 face=arial><b><?php echo $pret;?><br><?php echo $suprafata;?><br><br><font face=verdana><?php echo $mzrow999[contact];?></b><br><br>
</td></tr>
</table>
</td>
<td width=450 valign=top align=left bgcolor=#f2f2f2><br>
<?php
if($mzrow999["poza1"]==da and $mzrow999["poza2"]==nu)
{
echo"<img border=1 src=poze/".$mzrow999[idoferta]."_1.jpeg vspace=3 hspace=3><br>";
}
if($mzrow999["poza2"]==da)
{
echo"<img border=1 src=poze/".$mzrow999[idoferta]."_2.jpeg vspace=3 hspace=3><br>";
}
if($mzrow999["poza3"]==da)
{
echo"<img border=1 src=poze/".$mzrow999[idoferta]."_3.jpeg vspace=3 hspace=3><br>";
}
if($mzrow999["poza4"]==da)
{
echo"<img border=1 src=poze/".$mzrow999[idoferta]."_4.jpeg vspace=3 hspace=3><br>";
}
if($mzrow999["poza5"]==da)
{
echo"<img border=1 src=poze/".$mzrow999[idoferta]."_5.jpeg vspace=3 hspace=3><br>";
}
?>
</td>
</tr>
<tr>
<td align=right colspan=2 bgcolor=#000000><?php include "elements/footer.php";}?>
</td></tr>
</table>
</div>
</body>
</html>