Search problem...

thefisherman

Hi !

I have something strange once again and can't figure it out.

Here's the case:

I have a search routine which searches by keyword entered through a database like this:

$SQL_statement = "SELECT * FROM maintable WHERE description LIKE '%$keyword%' LIMIT " . $start . "," . $limiet;

where $start=offset and $limiet=10, then $limiet is incremented by 10 and the search is done again.

Works...

Now, i want to search the keyword by category, so i do this:

$SQL_statement = "SELECT * FROM maintable WHERE description LIKE '%$keyword%' AND cat_id='$detectnumber' ORDER BY id, description LIMIT " . $start . "," . $limiet;

Let's say it finds 35 matches. Clikcing on page 2 (using a previous and next routine) should get me to page 2, but it gets me nothing. Clicking on page 2 increments $start and does the 2nd statement again btw.

So i'm a bit lost. Is the upper code correct?

Any hints would be really helpfull..

Fish

laserlight

Could use:
$start = ($page - 1) * $offset;

So if you have an offset of 10, then for page 3 the start would be (3-1)*10=20, i.e. you skip the first 20 rows that satisfy the query, then with limit, or $limiet as you named it, it returns that number of rows.

Of course you'll have to check that things like $detectnumber are still around when you do the second query, which I presume will be from some link or button.

thefisherman

Try the site and search, you'll see

www.graphicalsolutions.nl

Fish

thefisherman

Hi !

I got that as well:

$start = ($page - 1) * $offset;

And a lot other stuff, it's hard to mention what i am already doing.

I think i found an error:

I use $resultset as the receiver of data. But i never free the results anywhere.

I tried this on the site:

Search for: flower
Categorie: Nature

Gave me 46 results. Though when i use the commandline and type the same query, it gives me 38!

So i think the first time the results are right (38) and the links work correctly, but the last page will carry an array of 8. Is this kept in the array until it's freed? Because the last 8 + a new search of 38 would result in 46! And the links do not work correctly anymore!

Am i making sense here?

Fish

p.s. thanks for help!