<?php $result = mysql_query("select Apelido, Email, Pontuacao, Level, Cor, Animal, Lugar, Sonho, Outros, Camfoto from usuarios ORDER BY `Nome`", $conexao_meu); while($row = mysql_fetch_array($result)) { echo "<tr> <td valign=\"top\" width=\"25%\"><div align = \"center\"><b>", $row["Apelido"], "</b><br><br> <img src=\"images/avatar/" , $row["Camfoto"], ".gif\"></div></td> <td width=\"75%\" colspan=\"3\"> <table class=\"peq\" width=\"100%\" > <tr> <td width=\"70\" valign=\"top\"> E-mail: </td> <td width=\"\">", $row["Email"], "</td> </tr> <tr> <td valign=\"top\"> Cor: </td> <td>", $row["Cor"], "</td> </tr> <tr> <td valign=\"top\"> Animal: </td> <td >", $row["Animal"], "</td> </tr> <tr> <td valign=\"top\"> Lugar: </td> <td>", $row["Lugar"], "</td> </tr> <tr> <td valign=\"top\"> Sonho: </td> <td>", $row["Sonho"], "</td> </tr> <tr> <td valign=\"top\"> Outros: </td> <td>", $row["Outros"], "</td> </tr> <tr> <td valign=\"top\"> Pontuação: </td> <td>", $row["Pontuacao"], "</td> </tr> <tr> <td valign=\"top\"> Level: </td> <td>", $row["Level"], "</td> </tr> <tr> <td> <hr size=\"1\"> </td> <td> <hr size=\"1\"> </td> </tr> </table> </td> </tr>"; } mysql_free_result($result); ?>
Como eu faço pra agrupar as saidas de 10 em 10, mostrando: Página seguinte, anterior...