displaying records help

[robinson]

I have php code that displays the records in html table... each record has its onw table. currently it displays every record... how do i display for example 5 records at a time..
the code is in php and using mysql.
view the results at http://www.comgen.ca/phptest/main1.php

insted of displaying the whole record on onec i like to display little bit at a time with maybe a button or a link to display the next 5 number..on in the same page.. so display the first 5 records and then display the next 5 on top of the first 5...of course at the end i might me less then 5 which has to be look at as well..
any ideas you can give me would be greatly appreciate.

[sarahk]

Hi Robin

there are lots of tutorials for this kind of thing. When you send your select down to mysql you can add "limit 5" to the end of the query and only get the first 5.

there are even classes to manage it all for you. If you don't want to use other people's work at least use them to learn from.

[bretticus]

basically do this:
<?
$limit_to = 5;
if (!isset($page)){$page=1;}

$curr_index = ($limit_to * $page) - $limit_to;

$query = "SELECT * FROM table LIMIT $curr_index, $limit_to"

?>
<a href="$PHP_SELF?page=<?=$pg-1?>">back</a> - <a href="$PHP_SELF?page=<?=$pg+1?>">forward</a>

[salim]

hi,

can u give me the similar query statement for access database.

thanx