";?>
=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/properties2.php on line 125