₦airaland Forum

hello guys,
need some help with my php codes
i intend to dynamically generate a search query which would depend on the selections made by the search visitor
so far this is how far i have gone.
I have tried the SQL string in phpmyadmin and it works however when i insert my string into the dbase. it generates an SQL error. Can some one pls tell me where i am getting it wrong?

include("database_connector";
$searchTerm=NULL;
$var =NULL;
if(isset($_GET)){
#Get the property type
if(!empty($_GET['proptype'])){
$propType=$_GET['proptype'];
$prop='propType=';
$prop.='\''.$propType.'\'';
}
#Get the number of rooms
if(!empty($_GET['minRm'])||(!empty($_GET['maxRm']))){
$minroom = isset($_GET['minRm'])?$_GET['minRm']:'0';
$minRoom=' AND (num_bedrm>='.'\''.$minroom.'\'';
$maxroom = isset($_GET['maxRm'])?$_GET['maxRm']:NULL;
$var.='OR num_bedrm<='.'\''.$maxroom.'\'';
$var.=')';
}
#Get the price range
if(!empty($_GET['pRange'])){
$pRange=isset($_GET['pRange'])?$_GET['pRange']:NULL;
$var.=' AND price_range=';
$var.='\''.$pRange.'\'';
}
#check the variable to ensure it is not empty
if(!empty($var)){
$var.=' AND ';
}
#get whether it is for sale or rent
if(!empty($_GET['cat'])){
$var.='transType=';
$cat=($_GET['cat']=='rent')? 'rent':'sale' ;
$var.='\''.$cat.'\'';
}
#Get the location
if(!empty($_GET['location'])){
$var .= ' AND location=';
$var .='\'';
$var.=($_GET['location']=='')?NULL:$_GET['location'];
$var .='\'';
}
$req = "SELECT * FROM properties WHERE $var";
$req1= mysqli_query($conn,$req);
$numResult = mysqli_num_rows($req1);
$curPage = isset($_GET['page'])? $_GET['page'] : 1;
$limit = 4;
$numPages = ceil($numResult/$limit);
$start = ($curPage-1)*4;
include("pagination2.php";
displayResult($var,$limit,$start);
echo $displayRes;
echo "<p>";
showLinks($var,$curPage,$numPages);
echo '<div style="clear:both; padding-top: 10px; padding-bottom:10px">'.$pageLinks."</div>";
?>

what is the error you are getting?

I don't know,I want to learn!

when you post a programming programming without displaying error message. . . .or showing an online sample. . .

sry guys,
problem solved!

Still go ahead to post what the error was and how it was solved.

exactly