next resultset ???

Anon

Hi all,

I have got atleast 10,000 entries in my database. What I want to do is, to Display 10 entries in one page.

My problem is :

1) If I have got 10,000 rows after running a SQL Query and I want to display only 10 per page.. what wiil be the best procedure to do it ??

Should I store these values in Temporary table and then call the next values on each page ??

Should I store these values in an Array and paas it to the next page??

Can we again get that "old" resultset which was fetched in first page ??

How it will be possible ??

[deleted]

You should start by searching the web. This very forum is full of similar questions wuth even more answers.

The solution is to just run the same query every time you need a page of results. The only thing that changes every time is the number of results you return. Search the forums for more details.

Anon

Take Vincent's advice. Earlier this week a similar question was asked. Use LIMIT in your sql query.

Anon

Yeah I have done it .. Actually it is possible in so many ways.. I do not know why I used to ask this kind bullshit questions even I know that I am able to solve it myself..

Anyway..

Vincent thanx again..