Alright so I have this script(see below) and all it does is display my mysql table. Is there a way for this script to hit a maximum number of entries, then post it on another page?
echo "<table border='0'>";
echo "<tr> <th> <u>Team name</u> </th> <th> <u>Captain</u> </th> <th> <u>Member 2</u> </th> <th> <u>Member 3</u> </th> <th> <u>Member 4</u> </th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['team_name'];
echo "</td><td>";
echo $row['captain'];
echo "</td><td>";
echo $row['member_2'];
echo "</td><td>";
echo $row['member_3'];
echo "</td><td>";
echo $row['member_4'];
echo "</td></tr>";
}
echo "</table>";
?>
I want this because my users post their teams etc, and the page is beginning to become a little bit cluttered. I just want to split it up into a few pages.
Thanks guys!
