Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ?php
- $username="casta_classifica";
- $password="giuseppe";
- $database="castagro_classifica";
- mysql_connect(localhost,$username,$password);@mysql_select_db($database) or die("Impossibile selezionare il database");
- $query="SELECT * FROM classifica";
- $risultati=mysql_query($query);
- $num=mysql_numrows($risultati);
- mysql_close();
- ?>
- <table border="0" cellspacing="2" cellpadding="2">
- <tr>
- <th><font face="Arial, Helvetica, sans-serif">Nome</font></th>
- <th><font face="Arial, Helvetica, sans-serif">Punti</font></th>
- <th><font face="Arial, Helvetica, sans-serif">Vittorie '</font></th>
- <th><font face="Arial, Helvetica, sans-serif">Pareggi'</font></th>
- <th><font face="Arial, Helvetica, sans-serif">Sconfitte'</font></th>
- </tr>
- <?php
- $i=0;
- while ($i < $num) {
- $nome=mysql_result($risultati,$i,"nome");
- $punti=mysql_result($risultati,$i,"punti");
- $vittorie=mysql_result($risultati,$i,"vittorie");
- $pareggi=mysql_result($risultati,$i,"pareggi");
- $sconfitte=mysql_result($risultati,$i,"sconfitte");
- ?>
- <tr>
- <td><font face="Arial, Helvetica, sans-serif"></font></td>
- <td><font face="Arial, Helvetica, sans-serif"></font></td>
- <td><font face="Arial, Helvetica, sans-serif"><?php echo $eta;?></font></td>
- </tr>
- <?php
- $i++;
- }
- ?>
Add Comment
Please, Sign In to add comment