Next Previous Records

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
gaddimanish
Forum Newbie
Posts: 8
Joined: Thu Mar 25, 2004 3:44 am

Next Previous Records

Post by gaddimanish »

I have 1000 records in table

I want to display in this format

Next 2.3---99 Previous(10 records per page)

How i can display this through my php page

Manish
Straterra
Forum Regular
Posts: 527
Joined: Mon Nov 24, 2003 8:46 am
Location: Indianapolis, Indiana
Contact:

Post by Straterra »

Almost noone here will give you 3 pages worth of code so do what you want. Rather, read the PHP Manual about MySQL and SQLite. We are here to help with the individual tasks, such as getting a certain collumns information. We are not here to write your code for you.
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

gaddimanish - don't double-post please.

regarding your question: have a look at the limit function in the mysql manual.

An example usage would be "SELECT * FROM myTable LIMIT 0,10".
gaddimanish
Forum Newbie
Posts: 8
Joined: Thu Mar 25, 2004 3:44 am

Post by gaddimanish »

sorry

Actually I know this

An example usage would be "SELECT * FROM myTable LIMIT 0,10".

I m using th same thing in my code,I jut wanted to know is there any way so that after clicking next no query will be exceuted again.

Once the query execute my result would be stored in result set and i will get from there and no need to execute query again and again by changing limit(which is i m currently doing)

Manish
Post Reply