Mysql Query

[Anon]

Please help with this query.

select count(id) FROM personals WHERE (descr like '%' || title like '%') && (TO_DAYS(CURRENT_DATE)-TO_DAYS(posted)<=60) && (age >= '18') && (age <= '99') limit 10, 10

My table contains 12 records that match the search, and the above query should return the last two records, since I have LIMIT 10,10.

This query:

select count(id) FROM personals WHERE (descr like '%' || title like '%') && (TO_DAYS(CURRENT_DATE)-TO_DAYS(posted)<=60) && (age >= '18') && (age <= '99') limit 0, 10

returns the first ten records without a problem, the first query however, gives me the error:

Warning: Unable to jump to row 0 on MySQL result index 2.

Any help is appreciated. Thanks.

Richie.

[mattw]

Hmmm..I don't know how the second query is giving you the results you say. By using count(id), you are only going to have one row returned and that is only going to have one field named count(id) which contains the number of rows that match the where clause.....

Matt Wade
codewalkers.com

[tomhath]

Adding to what Matt said, the first query tries to skip the first ten rows of the result set and return rows 11 through 20. You are probably getting the warning because the query could only return a single row.

[Anon]

I've different things, and I'm still getting the same error. Thanks for your responses anyway.

[[deleted]]

Your queries are quite strange in that you are indeed counting results and limiting the number of results at the same time.

The error you get simply means that you are trying to access a row from the result, but the resultset is empty.
You must always check that you have results before accessing them.