auto generated php page from database

[Anon]

Hi,

I have about 20 records in a table, in a mysql database.

what i want to do is to generate a page, and only display 5 records at a time, then print out a Next, Previous Link. and when next is clicked, the next 5 will be shown...

Can somebody help me?

Thank you very much!

[Anon]

Take a look at this http://PHPBUILDER.COM/columns/rod20000221.php3

[Anon]

I really haven't done this... but I think you can solved it with something like this....

SELECT field1,field2 FROM mytable LIMIT 1,5

the syntax for LIMIT is:

LIMIT [start,]rows

so just keep track of where to start and change it on the <NEXT> link .

I hope this helps.

Sang Nguyen wrote:

Hi,

I have about 20 records in a table, in a mysql database.

what i want to do is to generate a page, and only display 5 records at a time, then print out a Next, Previous Link. and when next is clicked, the next 5 will be shown...

Can somebody help me?

Thank you very much!

[Anon]

Sang,

You're just in luck. I just did this a few days ago. Give me your e-mail and I'll send the my code for this.

[Anon]

my email is: [e-mail]

thank you