Originariamente inviato da Samleo
I range di prezzi come li inserisci?

Hai delle select preimpostati?
ti posto lo script completo :

<?php
include("connessione.php");
$stringa=$_POST[stringa];
if (!$stringa or $stringa==""){
echo "<font face=\"arial\" size=\"2\">E' necessario specificare la/le parola/parole da cercare
<a href=\"javascript:history.back()\">indietro</a></font>";
exit();
}
$cn=mysql_connect($host,$uid,$pw);
mysql_select_db($db,$cn);
$sql="SELECT * FROM $tabella WHERE ";
$lista_parole=explode(" ",$stringa);
for($i=0;$i<count($lista_parole);$i++)
{
$str.="titolo LIKE '%$lista_parole[$i]%' OR ";
}
$str=substr($str,0,(strlen($str)-3));
$sql.=$str;

$prezzoDA = eregi_replace(".","",$_POST['prezzoDA']);
$prezzoA = eregi_replace(".","",$_POST['prezzoA']);

$prezzoDA = (preg_match( "/^(\d+),?(\d{1,2})?$/" , $_POST['prezzoDA'] )) ? $_POST['prezzoDA'] : 0;
$prezzoA = (preg_match( "/^(\d+),?(\d{1,2})?$/" , $_POST['prezzoA'] )) ? $_POST['prezzoA'] : 0;
if ($prezzoA > $prezzoDA) {
$prezzoA = $prezzoDA;
}
if ($prezzoDA > 0 && $prezzoA > 0) {
$sql .= " AND prezzo BETWEEN {$prezzoA} AND {$prezzoDA}";
} else if ($prezzoDA > 0 && $prezzoA <= 0) {
$sql .= " AND prezzo >= {$prezzoDA}";
} else if ($prezzoDA <= 0 && $prezzoA > 0) {
$sql .= " AND prezzo <= {$prezzoA}";
}

$mqDA = (preg_match( "/^(\d+),?(\d{1,2})?$/" , $_POST['mqDA'] )) ? $_POST['mqDA'] : 0;
$mqA = (preg_match( "/^(\d+),?(\d{1,2})?$/" , $_POST['mqA'] )) ? $_POST['mqA'] : 0;
if ($mqA > $mqDA) {
$mqA = $mqDA;
}
if ($mqDA > 0 && $mqA > 0) {
$sql .= " AND mq BETWEEN {$mqA} AND {$mqDA}";
} else if ($mqDA > 0 && $mqA <= 0) {
$sql .= " AND mq >= {$mqDA}";
} else if ($mqDA <= 0 && $mqA > 0) {
$sql .= " AND mq <= {$mqA}";
}

$local=$_POST[loc];
$par_cit=explode(" ",$local);
for($u=0;$u<count($par_cit);$u++)
{
$sql .=" AND citta LIKE '%$par_cit[$u]%'";
}


$sql.=" ORDER BY id";
$query=mysql_db_query($db,$sql);
$num=mysql_num_rows($query);

$query=mysql_db_query($db,$sql);
$num=mysql_num_rows($query);
?>