Este código que envio junto , faz com que eu eu consiga ober resultados desta pesquisa numa página do WEBSITE que faço a pesquisa. O que eu preciso também é ao fazer a pesquisa num website (website.com), me reencaminhe para outro website (website.pt), ou seja tal como na situação anterior, este código está num website(website.com), e quando clico na foto, me abre a informação pretendida, numa outra página do mesmo website. O que preciso é que me abra uma página igual MAS em um novo e diferente website(website.pt) e noutra janela. a diferença desta situação para com a anterior que coloquei antes, é que na anterior só preciso que me dê O MESMO OBJECTO ENTRE O PREÇO X E PREÇO Y DE UM CERTO PAÌSa que corresponde um certo website ( para portugal por exemplo website.pt, para os objectos entre esses preços no brasil terá que abrir em website.br: Nesta nova situação a pesquisa terá que me dar toda a informação de TODOS OS TIPOS de objectos NUM DETERMINADO PAÍS, abrindo da mesma forma noutro website noutra janela. as origens das pesquisas são sempre feitas no website #1 (website.com) o resultado pode ser num website #2 (website.pt) ou num website #3 ( website.br) e assim sucessivamente. possivelmente terei que criar uma tabela especial na minha base de dados e usar um sql. <table align="center" width="95%" border="0" cellspacing="0" cellpadding="0" style="BORDER-RIGHT: #093 1px solid; BORDER-TOP: #093 1px solid; BORDER-LEFT: #093 1px solid; BORDER-BOTTOM: #093 1px solid">
<tr>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b>
<a href="search.php?ord=id&ord2=asc&countrylet=<? echo "$countrylet"; ?>&rentalperiod=<? echo"$rentalperiod"; ?>&<? echo"$rentalperiod"; ?>=1"><img src="images/up.gif" width="14" height="15" border="0" /></a></b></font> </div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b>Order by</b></font></div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b><a href="search.php?ord=id&ord2=desc&countrylet=<? echo "$countrylet"; ?>&rentalperiod=<? echo"$rentalperiod"; ?>&<? echo"$rentalperiod"; ?>=1"><img src="images/down.gif" width="14" height="15" border="0" /></a></b></font></div></td>
<td><div align="center"> </div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b><a href="search.php?ord=tipo&ord2=asc&countrylet=<? echo ($countrylet); ?>&rentalperiod=<? echo"$rentalperiod"; ?>&<? echo"$rentalperiod"; ?>=1"><img src="images/up.gif" width="14" height="15" border="0" /></a></b></font></div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b>Order by</b></font></div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b><a href="search.php?ord=tipo&ord2=desc&countrylet=<? echo ($countrylet); ?>&rentalperiod=<? echo"$rentalperiod"; ?>&<? echo"$rentalperiod"; ?>=1"><img src="images/down.gif" width="14" height="15" border="0" /></a></b></font></div></td>
<td><div align="center"> </div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b><a href="search.php?&ord=cidade&ord2=asc&countrylet=<? echo ($countrylet); ?>&rentalperiod=<? echo"$rentalperiod"; ?>&<? echo"$rentalperiod"; ?>=1"><img src="images/up.gif" width="14" height="15" border="0" /></a></b></font></div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b>Order by</b></font></div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b><a href="search.php?&ord=cidade&ord2=desc&countrylet=<? echo ($countrylet); ?>&rentalperiod=<? echo"$rentalperiod"; ?>&<? echo"$rentalperiod"; ?>=1"><img src="images/down.gif" width="14" height="15" border="0" /></a></b></font></div></td>
<td><div align="center"> </div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b><a href="search.php?ord=<? if($rentalperiod=="venda") echo"precomax"; if($rentalperiod=="aluga") echo"precodia"; ?>&ord2=asc&countrylet=<? echo ($countrylet); ?>&rentalperiod=<? echo"$rentalperiod"; ?>&<? echo"$rentalperiod"; ?>=1"><img src="images/up.gif" width="14" height="15" border="0" /></a></b></font></div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b>Order by</b></font></div></td>
<td align="center" valign="middle"><font face="Verdana" size="1" color="#000000"><b><a href="search.php?ord=<? if($rentalperiod=="venda") echo"precomax"; if($rentalperiod=="aluga") echo"precodia"; ?>&ord2=desc&countrylet=<? echo ($countrylet); ?>&rentalperiod=<? echo"$rentalperiod"; ?>&<? echo"$rentalperiod"; ?>=1"><img src="images/down.gif" width="14" height="15" border="0" /></a></b></font></div></td>
</tr>
<tr>
<td width="750" colspan="15"></td>
</tr>
<tr>
<td><div align="center"></div></td>
<td><div align="center"><font face="arial" size="1" color="#000000">AD</font></div></td>
<td><div align="center"></div></td>
<td><div align="center"> </div></td>
<td><div align="center"></div></td>
<td><div align="center"><font face="arial" size="1" color="#000000">Type</font></div></td>
<td><div align="center"></div></td>
<td><div align="center"> </div></td>
<td><div align="center"></div></td>
<td><div align="center"><font face="arial" size="1" color="#000000">City</font></div></td>
<td><div align="center"></div></td>
<td><div align="center"> </div></td>
<td><div align="center"></div></td>
<td><div align="center"><font face="arial" size="1" color="#000000">Price</font></div></td>
<td><div align="center"></div></td>
</tr>
</table>
<?
$ord=$_POST['ord'];
$ord2=$_POST['ord2'];
$countrylet=$_POST['countrylet'];
$rentalreriod=$_POST['rentalperiod'];
if(!$countrylet){
$countrylet=$_GET['countrylet'];
}
if(!$rentalperiod){
$rentalreriod=$_GET['rentalperiod'];
}
$tipologia=$rentalperiod;
if(!$ord and !$ord2){
$ord = $_GET['ord'];
$ord2 = $_GET['ord2'];
}
$rowsPerPage = 10;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
if($rentalperiod=="venda") $sql2 = "select * from carteira where pais ='$countrylet' and $rentalperiod='1' and imovactivo='1' order by $ord $ord2";
if($rentalperiod=="aluga") $sql2 = "select * from carteira where pais ='$countrylet' and $rentalperiod='1' and imovactivo='1' order by $ord $ord2";
$reg2 = mysql_db_query("website_principal_origem_da_pesquisa",$sql2);
$q1 = mysql_num_rows($reg2);
// $sql="select * from carteira";
$reg = mysql_query($sql,$ligacao);
if ($q1 > 0){
echo("<div align =\"center\"><br><br><font face =\"verdana\" size =\"1\" color=\"#000000\"><b>THERE ARE<font face =\"verdana\" size =\"2\" color=\"#ff0000\"> $q1 ");
if($rentalperiod=='venda') { echo"<font face =\"verdana\" size =\"1\" color=\"#000000\">PROPERTIES FOR SALE "; }
if($rentalperiod=='aluga') { echo"<font face =\"verdana\" size =\"1\" color=\"#000000\">PROPERTIES TO LET "; }
echo"IN<font face =\"verdana\" size =\"2\" color=\"#ff0000\"> $countrylet</b></font><br><br></div>";
} else {
echo"<div align =\"center\"><br><br><font face =\"verdana\" size =\"1\" color=\"#000000\"><b>THERE ARE<font face =\"verdana\" size =\"2\" color=\"#ff0000\"> $q1 ";
if($rentalperiod=='venda'){ echo"<font face =\"verdana\" size =\"1\" color=\"#000000\">PROPERTIES FOR SALE "; }
if($rentalperiod=='aluga'){ echo"<font face =\"verdana\" size =\"1\" color=\"#000000\">PROPERTIES TO LET "; }
echo"IN<font face =\"verdana\" size =\"2\" color=\"#ff0000\"> $countrylet</b></font><br><br></div>";
}
if($rentalperiod=="venda") $sql3 = "select * from carteira where pais ='$countrylet' and $rentalperiod='1' and imovactivo='1' order by $ord $ord2 limit $offset, $rowsPerPage";
if($rentalperiod=="aluga") $sql3 = "select * from carteira where pais ='$countrylet' and $rentalperiod='1' and imovactivo='1' order by $ord $ord2 limit $offset, $rowsPerPage";
$reg = mysql_db_query("website_principal_origem_da_pesquisa",$sql3);
$maxPage = ceil($q1/$rowsPerPage);
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <font face = \"verdana\" size = \"1\" color = \"#000000\"><a href=\"search.php?countrylet=$countrylet&rentalperiod=$rentalperiod&$rentalperiod=1&ord=id&ord2=asc&page=$page\">";
if($countrylet!="")
$prev.="Previous $countrylet properties</a></font>";
if($countrylet=="")
$prev.="Previous properties</a></font>";
$first = " <font face = \"verdana\" size = \"1\" color = \"#000000\"><a href=\"search.php?countrylet=$countrylet&rentalperiod=$rentalperiod&$rentalperiod=1&ord=id&ord2=asc&page=1\">First page</a></font> ";
}
else
{
$prev = ' <font face = "verdana" size = "1" color = "#cccccc">';
if($countrylet!="")
$prev.="Previous $countrylet properties</font>";
if($countrylet=="")
$prev.="Previous properties</font>";
$first = ' <font face = "verdana" size = "1" color = "#cccccc">First page</font> '; // nor 'first page' link
}
// print 'next' link only if we're not
// on the last page
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <font face=\"verdana\" size=\"1\" color=\"#000000\"><a href=\"search.php?countrylet=$countrylet&rentalperiod=$rentalperiod&$rentalperiod=1&ord=$ord&ord2=$ord2&page=$page\">";
if($countrylet!="")
$next.="Next $countrylet properties</a></font>";
if($countrylet=="")
$next.="Next properties</a></font>";
$last = "<font face=\"verdana\" size=\"1\" color=\"#000000\"><a href=\"search.php?countrylet=$countrylet&rentalperiod=$rentalperiod&$rentalperiod=1&ord=$ord&ord2=$ord2&page=$maxPage\">Last page</a></font>";
}
else
{
$next = "<font face =\"verdana\" size =\"1\" color =\"#cccccc\">";
if($countrylet!="")
$next.="Next $countrylet properties</font>";
if($countrylet=="")
$next.="Next properties</font>";
$last = "<font face=\"verdana\" size=\"1\" color =\"#cccccc\">Last page</font>";
}
// print the page navigation link
echo "<div align='center'>" . $first . " " . $prev . " <font face ='verdana' size='1' color='#000000'> page <b>$pageNum</b> of <b>$maxPage</b> pages </font> " . $next . " " . $last . "<br><br>
</div>";
while($linhas=mysql_fetch_array($reg)){
$id = $linhas["id"];
$imagem = $linhas["imagem"];
$referencia ="<b>AD-</b>".$linhas["id"];
$tipo = $linhas["tipo"];
$cidade = $linhas["cidade"];
$pais = $linhas["pais"];
$precomin = $linhas["precomin"];
$precomax = $linhas["precomax"];
$precodia = $linhas["precodia"];
$precosemana = $linhas["precosemana"];
$precomes = $linhas["precomes"];
$precoano = $linhas["precoano"];
$tip = $linhas["tipo"];
$pais=$linhas["pais"];
$web=$linhas["website"];
$moeda=$linhas["moeda"];
$precomin=number_format($precomin,2,",",".");
$precomax=number_format($precomax,2,",",".");
$precodia=number_format($precodia,2,",",".");
$precosemana=number_format($precosemana,2,",",".");
$precomes=number_format($precomes,2,",",".");
$precoano=number_format($precoano,2,",",".");
if ($imagem==1){
$foto="ver_imo.php?&id=$id&referencia=$id&preço=$preço&tipo=$tip&tipologia=$tipologia";
$fotobg="admin/get_miniatura_a.php?img=2&cliente=$id&max_width=70";
$foto1="alugaver_imo.php?&id=$id&referencia=$id&preço=$preço&tipo=$tip&tipologia=$tipologia";
$foto1bg="admin/get_miniatura_a_1.php?img=2&cliente=$id&max_width=70";
}else{
$foto="<font face='Verdana' size='4'><a href='ver_imo.php?&id=$id'><img border='0' src='images/lupa.gif' width='23' height='27' alt='Ver oferta'></a></font>";
}
$maxPage = ceil($q1/$rowsPerPage);
if($rentalperiod=="venda"){
$pricelet = "SELECT least(
CASE WHEN precomin = '0'
THEN 999999999999999
ELSE precomin
END, CASE WHEN precomax = '0'
THEN 99999999999999999999
ELSE precomax
END) AS preço
FROM carteira
WHERE id ='$id'";
$priceq = mysql_db_query("website_principal_origem_da_pesquisa", $pricelet);
$resultletprice= mysql_fetch_array($priceq);
$preço=$resultletprice['preço'];
$preço=number_format($preço,2,",",".");
}
if($rentalperiod=="aluga"){
$pricesale="SELECT LEAST(CASE WHEN precodia = '0'
THEN 9999999999
ELSE precodia
END ,
CASE WHEN precosemana = '0'
THEN 999999999999
ELSE precosemana
END ,
CASE WHEN precomes = '0'
THEN 999999999999999
ELSE precomes
END ,
CASE WHEN precoano = '0'
THEN 99999999999999999999
ELSE precoano
END) AS preço FROM carteira WHERE id = '$id'";
$prices = mysql_db_query("website_principal_origem_da_pesquisa", $pricesale);
$resultsaleprice= mysql_fetch_array($prices);
$preço=$resultsaleprice['preço'];
$preço=number_format($preço,2,",",".");
}
?>
<table align="center" width="95%" cellspacing="0" cellpadding="0" style="BORDER-RIGHT: #093 1px solid; BORDER-TOP: #093 1px solid; BORDER-LEFT: #093 1px solid; BORDER-BOTTOM: #093 6px solid">
<tr>
<td width="11%" border="1" ><div align="center"><font face="verdana" size="2">Image</font></div></td>
<td width="10%" border="1"><div align="center"><font face="verdana" size="2">Ref</font></div></td>
<td width="17%" border="1"><div align="center"><font face="verdana" size="2">Type</font></div></td>
<td width="22%" border="1"><div align="center"><font face="verdana" size="2">City</font></div></td>
<td width="20%" border="1"><div align="center"><font face="verdana" size="2">Country</font></div></td>
<td width="20%" border="1"><div align="center"><font face="verdana" size="2">Currency</font></div></td>
<td width="30%" border="1"><div align="center"><font face="verdana" size="2">Price</font></div></td>
</tr>
<tr>
<td colspan="6"> </td>
</tr>
<tr>
<td width="11%" border="0" align="center">
<table width="78" height="70" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="6" colspan="3"> </td>
</tr>
<tr>
<td> </td>
<td width="60" height="55" background="<? if($rentalperiod=="venda") echo "$fotobg"; if($rentalperiod=="aluga") echo"$foto1bg"; ?>"><a href="<? if($rentalperiod=="venda") echo "$foto"; if($rentalperiod=="aluga") echo"$foto1"; ?>"><img src="images/spacer.gif" width="70" height="55" border="0" /></a></td>
<td> </td>
</tr>
<tr>
<td height="10" colspan="3"> </td>
</tr>
</table>
</div></td>
<td width="10%"><div align="center"><font face="verdana" size="1" color="#000000"><? echo"$referencia"; ?></font></div></td>
<td width="17%"><div align="center"><font face="verdana" size="1" color="#000000"><? echo"$tipo"; ?></font></div></td>
<td width="22%" border="1"><div align="center"><font face="verdana" size="1" color="#000000"><? echo($cidade); ?></font></div></td>
<td width="20%" border="1"><div align="center"><font face="verdana" size="1" color="#000000"><? echo ($pais); ?></font></div></td>
<td width="5%" border="1"><div align="center"><font face="verdana" size="1" color="#000000"><? echo ($moeda); ?></font></div></td>
<td width="30%" border="1"><div align="left"><font face="verdana" size="1" color="#000000">
<? if($precomax!="0,00" and $precomin!="0,00") echo"$precomax - max<br><br>$precomin - min"; if($precomax!="0,00" and $precomin=="0,00") echo"$precomax - max"; if($precomax=="0,00" and $precomin!="0,00") echo"$precomin";
if($precodia!="0,00" and $precosemana!="0,00" and $precomes!="0,00" and $precoano!="0,00") {
echo"$precodia - day<br><br>$precosemana - week<br><br>$precomes - month<br><br>$precoano - year";
}
if($precodia!="0,00" and $precosemana!="0,00" and $precomes!="0,00" and $precoano=="0,00") {
echo"$precodia - day<br><br>$precosemana - week<br><br>$precomes - month";
}
if($precodia!="0,00" and $precosemana!="0,00" and $precomes=="0,00" and $precoano=="0,00") {
echo"$precodia - day<br><br>$precosemana - week";
}
if($precodia!="0,00" and $precosemana=="0,00" and $precomes!="0,00" and $precoano=="0,00") {
echo"$precodia - day<br><br>$precomes - month";
}
if($precodia!="0,00" and $precosemana=="0,00" and $precomes=="0,00" and $precoano!="0,00") {
echo"$precodia - day<br><br>$precoano - year";
}
if($precodia!="0,00" and $precosemana=="0,00" and $precomes=="0,00" and $precoano=="0,00"){
echo"$precodia - day";
}
if($precodia=="0,00" and $precosemana!="0,00" and $precomes=="0,00" and $precoano=="0,00"){
echo"$precosemana - week";
}
if($precodia=="0,00" and $precosemana!="0,00" and $precomes!="0,00" and $precoano=="0,00"){
echo"$precosemana - week<br><br>$precomes - month";
}
if($precodia=="0,00" and $precosemana!="0,00" and $precomes=="0,00" and $precoano!="0,00"){
echo"$precosemana - week<br><br>$precoano - year";
}
if($precodia=="0,00" and $precosemana=="0,00" and $precomes!="0,00" and $precoano!="0,00"){
echo"$precomes - month<br><br>$precoano - year";
}
if($precodia=="0,00" and $precosemana=="0,00" and $precomes!="0,00" and $precoano=="0,00"){
echo"$precomes - month";
}
if($precodia=="0,00" and $precosemana=="0,00" and $precomes=="0,00" and $precoano!="0,00"){
echo"$precoano - year";
}
if($precodia!="0,00" and $precosemana!="0,00" and $precomes=="0,00" and $precoano!="0,00") {
echo"$precodia - day<br><br>$precosemana - week<br><br>$precoano - year";
}
?>
</font></div></td>
</tr>
</table>
<br>
<?
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <font face = \"verdana\" size = \"1\" color = \"#000000\"><a href=\"search.php?countrylet=$countrylet&RentalPeriod=$RentalPeriod&$RentalPeriod=1&ord=id&ord2=asc&page=$page\">";
if($countrylet!="")
$prev.="Previous $countrylet properties</a></font>";
if($countrylet=="")
$prev.="Previous properties</a></font>";
$first = " <font face = \"verdana\" size = \"1\" color = \"#000000\"><a href=\"search.php?countrylet=$countrylet&RentalPeriod=$RentalPeriod&$RentalPeriod=1&ord=id&ord2=asc&page=1\">First page</a></font> ";
}
else
{
$prev = ' <font face = "verdana" size = "1" color = "#cccccc">';
if($countrylet!="")
$prev.="Previous $countrylet properties</font>";
if($countrylet=="")
$prev.="Previous properties</font>";
$first = ' <font face = "verdana" size = "1" color = "#cccccc">First page</font> '; // nor 'first page' link
}
// print 'next' link only if we're not
// on the last page
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <font face=\"verdana\" size=\"1\" color=\"#000000\"><a href=\"search.php?countrylet=$countrylet&RentalPeriod=$RentalPeriod&$RentalPeriod=1&ord=$ord&ord2=$ord2&page=$page\">";
if($countrylet!="")
$next.="Next $countrylet properties</a></font>";
if($countrylet=="")
$next.="Next properties</a></font>";
$last = "<font face=\"verdana\" size=\"1\" color=\"#000000\"><a href=\"search.php?countrylet=$countrylet&RentalPeriod=$RentalPeriod&$RentalPeriod=1&ord=$ord&ord2=$ord2&page=$maxPage\">Last page</a></font>";
}
else
{
$next = "<font face =\"verdana\" size =\"1\" color =\"#cccccc\">";
if($countrylet!="")
$next.="Next $countrylet properties</font>";
if($countrylet=="")
$next.="Next properties</font>";
$last = "<font face=\"verdana\" size=\"1\" color =\"#cccccc\">Last page</font>";
}
?>
<br>
<?
// print the page navigation link
echo "<div align='center'>" . $first . " " . $prev . " <font face ='verdana' size='1' color='#000000'> page <b>$pageNum</b> of <b>$maxPage</b> pages </font> " . $next . " " . $last . "<br><br></div>";
?>
<font face="Verdana" size="1" color="#000000"><b><a href="search.php?ord=id&ord2=asc&countrylet=<? echo "$countrylet"; ?>&RentalPeriod=<? echo"$RentalPeriod"; ?>&<? echo"$RentalPeriod"; ?>=1"></a></b></font><font face="Verdana" size="1" color="#000000"><b><a href="search.php?ord=tipo&ord2=asc&countrylet=<? echo ($countrylet); ?>&RentalPeriod=<? echo"$RentalPeriod"; ?>&<? echo"$RentalPeriod"; ?>=1"></a></b></font><font face="Verdana" size="1" color="#000000"><b><a href="search.php?ord=pais&ord2=asc&countrylet=<? echo ($countrylet); ?>&RentalPeriod=<? echo"$RentalPeriod"; ?>&<? echo"$RentalPeriod"; ?>=1"></a></b></font><font face="Verdana" size="1" color="#000000"><b><a href="search.php?ord=<? if($RentalPeriod=="venda") echo"precomax"; if($RentalPeriod=="aluga") echo"precodia"; ?>&ord2=asc&countrylet=<? echo ($countrylet); ?>&RentalPeriod=<? echo"$RentalPeriod"; ?>&<? echo"$RentalPeriod"; ?>=1"></a></b></font> Será que me fiz entender? Muito Obrigado.
