after 10 results an other page

[piet bierbuik]

hi people

i have a script that retrieve all names form the database
but the list is getting to big (over 40)


i would like to create a page that splits up those 40 results.
so after 10 results you can click next to the next 10 results.

can someone modify this script for me

THX piet

[code]
name.php

<?php
$sql = "SELECT * FROM database";
$result = mysql_query($sql);

while ($rij = mysql_fetch_array($result))
{

echo ucfirst($rij['naam']);
 
<BR />
}
?>
[/code]

[Caesar]

Any chance we can get an English translation? :-P

[piet bierbuik]

sry done :D