Location: PHPKode > scripts > Open4Listing > list.php
<?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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b><u>".$mzrow999[titlu]."</b></u></font><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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>
Return current item: Open4Listing