Doing multiple pages with id_no

[Anon]

Is there any way to do multiple pages with a SQL queries like this:

SELECT c.country FROM recreation_main AS a JOIN country AS c WHERE a.id_no=$x AND a.cat_id=$y AND a.subcat_id=$z AND a.country_id=c.country_id LIMIT $offset,$limit

It seems that I cannot use the LIMIT function as I've specifically called the id_no. Is there a way out??

[Anon]

If the id is unique (as it should be), well, then no wonder you get no more than a record. Else, no idea.

Hope it helps

fLIPIS

[Anon]

So there's really no way out for me??

[flipis]

Try to select a field not so unique and order by id. You can the display the data paginated

fLIPIS