Pagination Working With Multiple Variables [Split From Existing Thread]

[geezz]

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

[MDCode]

Please do not post an issue in another person's topic. You first query should work except you misspelled a variable

[geezz]

my bad noobie here

 

thx for the fast reply

 

well it was a typo by me...im pulling my hair cuz it should work but it doesnt why would two variables work and not all of them

[MDCode]

If they are not defined in the url, it would explain it. I've tested it on my site with no errors.

[geezz]

how would i do this? any ideas

[MDCode]

 

http://yourdomain.com/yourfile.php?province=whatever&city=blah&k=k&t=rawr

Edited December 3, 2012 by SocialCloud

[geezz]

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%\"";