[RESOLVED] pagination with conditional query

[watts]

Hi,
I'm creating a stock photo site and I'm having troubles with displaying selected results (just one category) and paginating it so that it displays a set number on each page and has the next and previous buttons. I found some code using LIMIT but I guess that's absolute in as much as it just starts at the record in the db in the $offset position and goes to the limit. What I need is something that will perform the same function as LIMIT but only within the results of my conditional query.

I tried this:

$queryImg = "SELECT * FROM images WHERE imgFeatured='no' AND imgID IN
(SELECT DISTINCT imgsubjoin.imgID FROM imgsubjoin WHERE imgsubjoin.subID = $GsubID) LIMIT $limitValue, $f_limit";

but I just get an error saying: Warning: extract() [function.extract]: First argument should be an array in.

I know there's a way to do this, since any online catalogue would need the same thing but I just don't know what it is.

Any ideas?

[bpat1434]

what does your other code look like? Do you get any mySQL errors? The extract is expecting an array, so unless you convert the result to an array using mysql_fetch_array() it won't work....

[watts]

I've figured out the problem. I had the imgFeatured field set up as binary in MySQL and it had tacked an extra character after the 'no' so I fixed that in the db and everything is fine now.

[bpat1434]

fantastic!!

+Kudos for marking resolved!!