Jump to content

Pagination Working With Multiple Variables [Split From Existing Thread]


geezz

Recommended Posts

nice right up...

 

i just have a slight problem getting this pagination working with multiple variables

 

 

$province = $_GET['province'] ;

$city = $_GET['city'] ;

$keyword = $_GET['k'] ;

$titles = $_GET['t'] ;

 

my query is the problem

 

ive tried

 

$sql ="SELECT * FROM $tbl_name WHERE provinces = '".$_GET['province']."' AND city = '".$_GET['city']."' AND title like\"%$titles%\" AND keywords like\"%$keywords%\"";

or

$sql = "SELECT * FROM search WHERE provinces = '$province' AND city = '$city' AND title like'{$titles}_' AND keywords

like'{$keyword}_'";

 

if i just put two variable it work

 

$sql ="SELECT * FROM $tbl_name WHERE provinces = '".$_GET['province']."' AND city = '".$_GET['city']."'

or

$sql = "SELECT * FROM search WHERE provinces = '$province' AND city = '$city'

 

how do i implement these 4 variable in one query.. is there any other changes i need to do in this php script

 

any help will do

 

thx in advance

oh of course...

 

 

/search2.php?province=AB&city=edmonton&t=trompo&k=restaurant

 

now it show all my database it didint filter it using this

 

$sql ="SELECT * FROM $tbl_name WHERE provinces = '".$_GET['province']."' AND city = '".$_GET['city']."' AND title like\"%$titles%\" AND keywords like\"%$keyword%\"";

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.