OK
Here it his the php search program that I use. Sorry but the variables $ are in portuguese.
<html>
<body>
<? include("header0.inc.php"); ?>
<? include("topmain.inc"); ?>
<?
$ltipo=$lab_tipo["$tipo"];
if ($ord!="" and $ord2!=""){
print ("
<table border='0' width='635' cellspacing='0' cellpadding='0'>
<tr>
<td width='100%'><font face='verdana' size='1'>$lab_resultpesquisa : <b><font color='#06000'>$ltipo</font></b>
<font color='#000000'><b>$search</b></font></font></td>
</tr>
</table>
<table border='0' width='635' bgcolor='#f0f0f0' cellspacing='1' cellpadding='0'>
<tr>
<td width='16%' bgcolor='#d0d0d0'>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='33%' align='center'><a href='search.php?idioma=$idioma&ord=imagem&ord2=as c&tipo=$tipo&search=$search'><img border='0' src='images/up.gif' width='14' height='15'></a></td>
<td width='33%' align='center'><font face='Arial' size='1' color='#FFFFFF'>$lab_ordenar</font></td>
<td width='34%' align='center'><a href='search.php?idioma=$idioma&ord=imagem&ord2=de sc&tipo=$tipo&search=$search'><img border='0' src='images/down.gif' width='14' height='15'></a></td>
</tr>
</table>
</td>
<td width='8%' bgcolor='#d0d0d0'>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='33%' align='center' colspan=2> </td>
</tr>
</table>
</td>
<td width='9%' bgcolor='#d0d0d0'>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='33%' align='center'><a href='search.php?idioma=$idioma&ord=tipologia&ord2 =asc&tipo=$tipo&search=$search'><img border='0' src='images/up.gif' width='14' height='15'></a></td>
<td width='33%' align='center'><font face='Arial' size='1' color='#FFFFFF'>$lab_ordenar</font></td>
<td width='34%' align='center'><a href='search.php?idioma=$idioma&ord=tipologia&ord2 =desc&tipo=$tipo&search=$search'><img border='0' src='images/down.gif' width='14' height='15'></a></td>
</tr>
</table>
</td>
<td width='27%' bgcolor='#d0d0d0'>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='33%' align='center'><a href='search.php?idioma=$idioma&ord=localidade&ord 2=asc&tipo=$tipo&search=$search'><img border='0' src='images/up.gif' width='14' height='15'></a></td>
<td width='33%' align='center'><font face='Arial' size='1' color='#FFFFFF'>$lab_ordenar</font></td>
<td width='34%' align='center'><a href='search.php?idioma=$idioma&ord=localidade&ord 2=desc&tipo=$tipo&search=$search'><img border='0' src='images/down.gif' width='14' height='15'></a></td>
</tr>
</table>
</td>
<td width='25%' bgcolor='#d0d0d0'>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='33%' align='center'><a href='search.php?idioma=$idioma&ord=concelho&ord2= asc&tipo=$tipo&search=$search'><img border='0' src='images/up.gif' width='14' height='15'></a></td>
<td width='33%' align='center'><font face='Arial' size='1' color='#FFFFFF'>$lab_ordenar</font></td>
<td width='34%' align='center'><a href='search.php?idioma=$idioma&ord=concelho&ord2= desc&tipo=$tipo&search=$search'><img border='0' src='images/down.gif' width='14' height='15'></a></td>
</tr>
</table>
</td>
<td width='15%' bgcolor='#d0d0d0'>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='33%' align='center'><a href='search.php?idioma=$idioma&ord=preco&ord2=asc &tipo=$tipo&search=$search'><img border='0' src='images/up.gif' width='14' height='15'></a></td>
<td width='33%' align='center'><font face='Arial' size='1' color='#FFFFFF'>$lab_ordenar</font></td>
<td width='34%' align='center'><a href='search.php?idioma=$idioma&ord=preco&ord2=des c&tipo=$tipo&search=$search'><img border='0' src='images/down.gif' width='14' height='15'></a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width='16%'>
<p align='center'> </td>
<td width='8%'>
<p align='center'><font face='Verdana' size='2'>$lab_referencia</font></td>
<td width='9%'>");
if ($tipo=="Vivenda" or $tipo=="Apartamento" or $tipo=="Casa" or $tipo=="Quinta") echo "<p align='center'><font face='Verdana' size='2'>$lab_tipoimovelquartos</font></td>";
else echo "<p align='center'><font face='Verdana' size='2'>$lab_tipoimovel</font></td>";
print("
<td width='27%'>
<p align='center'><font face='Verdana' size='2'>$lab_localidade</font></td>
<td width='25%'>
<p align='center'><font face='Verdana' size='2'>$lab_concelho</font></td>
<td width='15%'>
<p align='center'><font face='Verdana' size='2'>$lab_preco</font></td>
</tr>");
include ("chamada.inc.php");
$basedados="global";
if ($tipo) $sql="select * from carteira where situacao=1 and tipo='$tipo'";
if (!$tipo) $sql="select * from carteira where situacao=1 ";
$order="order by $ord $ord2";
$zonas_variaveis="search=$search&idioma=$idioma&or d=$ord&ord2=$ord2&tipo=$tipo";
$campos_search="concelho referencia localidade tipologia descricaopt descricaouk";
$reg_pagina=28;
include("paginacao1.inc");
if ($reg_total>0){
if ($pag_total>1){ print ("
<tr>
<td width=\"100%\" bgcolor=\"#C0C0C0\" align=\"center\" colspan=\"6\">");
include("paginacao2.inc");
print ("</td></tr>");
}
while ($registo=mysql_fetch_array($resultado)) {
$id=$registo["id"];
$imagem=$registo["imagem"];
$tipologia=$registo["tipologia"];
$referencia=$registo["referencia"];
$localidade=$registo["localidade"];
$sector=$registo["sector"];
$preco=$registo["preco"];
$concelho=$registo["concelho"];
if ($idioma=="uk") $licenca=$registo["licencauk"];
else $licenca=$registo["licenca"];
$preco=number_format($preco,2,",",".");
$vendido=$registo["vendido"];
$tipologia=$lab_tipologia["$tipologia"];
$chama="ver_imo";
if ($vendido==0){
if ($imagem==1){
$foto="<a href='ver_imo.php?idioma=$idioma&id=$id'><IMG border='0' SRC='admin/get_miniatura.php?img=2&cliente=$id&max_width=60'> ";
}else{
$foto="<font face='Verdana' size='4'><a href='ver_imo.php?idioma=$idioma&id=$id'><img border='0' src='images/lupa.gif' width='23' height='27' alt='See offer'></a></font>";
}
}
if ($vendido==1){
$foto="<font face='Verdana' size='4'><a href='ver_imo.php?idioma=$idioma&id=$id'><img border='0' src='imagens/res.gif' width='60' alt='Ver Pedido'></a></font>";
}
if ($vendido==2){
$foto="<font face='Verdana' size='4'><a href='ver_imo.php?idioma=$idioma&id=$id'><img border='0' src='imagens/sold.gif' width='60' alt='Ver Pedido'></a></font>";
}
$tot=$tot+1;
print ("
<tr>
<td width='16%' height='40' bgcolor='#FFFFFF'><p align='center'>$foto</td>
<td width='8%' bgcolor='#FFFFFF'><p align='center'><font size='1' face='Arial'>$referencia</font></td>
<td width='9%' bgcolor='#FFFFFF'><p align='center'><font size='1' face='Arial'>$tipologia<br>$licenca</font></td>
<td width='27%' bgcolor='#FFFFFF'><p align='center'><font face='Verdana' size='1'>$localidade $sector</font></td>
<td width='25%' bgcolor='#FFFFFF'><p align='center'><font face='Verdana' size='1'>$concelho</font></td>
<td width='15%' bgcolor='#FFFFFF'><p align='right'><font face='Verdana' size='1'>$preco <font color='#FF0000'>€</font></font></td>
</tr>");
}
if ($pag_total>1){ print ("
<tr>
<td width=\"100%\" bgcolor=\"#C0C0C0\" align=\"center\" colspan=\"6\">");
include("paginacao2.inc");
print ("</td></tr>");
}
}
}
print ("</table>");
include("footer.inc.php"); ?>
</body>
</html>
For example the "lab_preco" is the variable that translates the word price into any language that I select.
Now here it is the search script that I want to modify:
<form method="POST" action="<? echo "search.php?idioma=$idioma&ord=id&ord2=desc" ?>"
<font face="Verdana" size="1">
</font><select size="1" name="tipo">
<option value='Vivenda'selected><? echo $lab_vivendas ?></option>
<option value='Apartamento'><? echo $lab_apartamentos ?></option>
<option value='Casa'><? echo $lab_casastipicas ?></option>
<option value='Quinta'><? echo $lab_quintas ?></option>
<option value='Ruina'><? echo $lab_ruinas ?></option>
<option value='Terreno'><? echo $lab_terrenos ?></option>
<option value='Comercio'><? echo $lab_comercios ?></option>
<option value='Investimento'><? echo $lab_investimentos ?></option>
<option value='Investimento'><? echo $lab_propriedades ?></option>
</select> <input type="text" name="search" size="15">
<input type="submit" value="Go" name="B1" ></form></td>
I hopte that can help
Thanks
