Page 1 of 1
Next Previous Records
Posted: Fri Mar 26, 2004 6:53 am
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
Posted: Fri Mar 26, 2004 7:30 am
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.
Posted: Fri Mar 26, 2004 7:33 am
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".
Posted: Fri Mar 26, 2004 11:08 pm
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