|
|
=1){
$typeids="";
$sqlprop=$sqlprop." (";
$h=0;
while ($rowtype=mysql_fetch_array($qrytype)){
$sqlprop=$sqlprop."property.typeid like '%,".$rowtype["typeid"].",%'";
/*if ($typeids=="")
$typeids="'".$rowtype["typeid"]."'";
else
$typeids=$typeids.",'".$rowtype["typeid"]."'";*/
$h++;
if ($h<$totla)
$sqlprop=$sqlprop." or ";
}
// echo $typeids;
$sqlprop=$sqlprop.")";
// $sqlprop=$sqlprop." typeid in(".$typeids.")";
} else {
$sqlprop=$sqlprop." property.typeid like '%,$typeid,%'";
}
}
//if ($priceid!='0' || $dateid!='0')
$sqlprop=$sqlprop." order by";
if ($priceid!='0') {
$sqlprop=$sqlprop." property.price";
if ($priceid=='H')
$sqlprop=$sqlprop." desc";
}
if ($priceid!='0')
$sqlprop=$sqlprop.",";
if ($dateid=='0') {
$sqlprop=$sqlprop." property.id";
//$sqlprop=$sqlprop." property.refno";
} elseif ($dateid=='M'){
$sqlprop=$sqlprop." property.id desc";
//$sqlprop=$sqlprop.", property.refno desc";
}
/*if ($dateid!='0') {
$sqlprop=$sqlprop." property.refno";
if ($dateid=='M'){
$sqlprop=$sqlprop." desc";
$sqlprop=$sqlprop.", property.id desc";
}
} */
//echo $sqlprop."
";
$qryprop=mysql_query($sqlprop) or die("Error : ".mysql_error());?>
There are
Fatal error: Call to undefined function mysql_num_rows() in /var/www/vhosts/caribbeanlandandproperty.com/httpdocs/properties.php on line 125
| | |