include "includes/left.php"; ?> |
|
if ($pcountryid=="0") {
$sqlprop="select * from property, countries where property.countryid=countries.countryid and countries.display=\"Yes\" and status!=\"Inactive\"";
$mcountryname="All Countries";
} else {
//$sqlprop="select * from property,countries where property.countryid=\"$pcountryid\" and property.status!=\"Inactive\"";
$mcountryname=$rowpage["countryname"];
$sqlprop="select * from property where property.countryid=\"$pcountryid\" and property.status!=\"Inactive\"";
$mcountryname=$rowpage["countryname"];
}
if ($typeid!='A'){
/*if ($pcountryid=='0')
$sqlprop=$sqlprop." where";
else*/
$sqlprop=$sqlprop." and";
$sqltype="select * from propertytype where ptypeid=\"$typeid\"";
$qrytype=mysql_query($sqltype) or die("Error : ".mysql_error());
$totla=mysql_num_rows($qrytype);
if (mysql_num_rows($qrytype)>=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
| | |