previous next pagination quickie question - please?

[orionblue]

Hello all,

I have a very nice previous | next pagination script that I found at

http://www.evolt.org/article/Multiple_Pages_With_PHP/17/19340/

and it is very well explained from what I can see -

BUT there is a line here that I cannot figure out.
My existing query which is:

SELECT * FROM contacts WHERE l_area IN ('" . implode("','", $POST['l_area']) . "') AND l_type IN ('" . implode("','", $POST['l_type']) . "') AND l_active=1 and l_status='$l_status' OR l_id='$ref'

Does not fit nicely into:

SELECT * FROM your_table WHERE name LIKE '%". $query ."%'"); // the query.

I get no results when I add my WHERE like this:

SELECT * FROM contacts WHERE '%". l_area IN ('" . implode("','", $POST['l_area']) . "') AND l_type IN ('" . implode("','", $POST['l_type']) . "') AND l_active=1 and l_status='$l_status' OR l_id='$ref'

Can someone please check this out and let me know how I've botched this pretty straight-forward code?

[diego25]

Try

 "SELECT * FROM contacts WHERE l_area IN ('" . implode("','", $_POST['l_area']) . "') AND l_type IN ('" . implode("','", $_POST['l_type']) . "') AND l_active=1 and l_status='$l_status' OR l_id='$ref'"

Diego

[orionblue]

Thanks, but that was the first variation on the script that I had (I'm sorry, I should have included that in my previous post). It didn't work!

• any more suggestions?