include("lib/connect.php");
$sql = "select * from pai_hotel where 1=1";
if(isset($_REQUEST['price'])) {
$price = $_REQUEST['price'];
list($min,$max) = split("-", $price);
$sql .= " and price between $min and $max";
}
if(isset($_REQUEST['namea'])) {
$sql .= " order by name";
}
if(isset($_REQUEST['namez'])) {
$sql .= " order by name desc";
}
$query = mysql_query($sql) or die ("error=$sql");
$num = mysql_num_rows($query);
?>