PHP HTML iterating through result set from mysql

Hi guys

i know this is probably basic PHP but im at that level!

can anyone give me some php and html code that will iterate through results from a mysql table using html NEXT, Previous Buttons.

iv been trying it but when i press a next button the page seems to refresh to the original and showing up the first entry.

Any Help appreciated

Cheers Ian

 

You mean pagination?

 

any code to help me out on pagination mate?

 

You can't iterate through a dbase like that in real-time.

Unless you hack around it with AJAX.

 

thats what i was afraid off!!!!!!

 

here is a tutorial for paging sql results.

hxxp://www.php-mysql-tutorial.com/php-mysql-paging.php

 

cheers highborn il have a look

 

You might want to check out the pager package from http://pear.php.net/package/Pager

There is also a link in there to some examples, I have used this package before on a site of mine and its very good