Guest User

Untitled

a guest
Jul 22nd, 2012
51
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <title>Lista Bannati CruserMt2</title>
  2. <body bgcolor="black" text="white">
  3. <table border="5" width="30%" align="center">
  4. <tr><th>Posizione</th><th>ID ACCOUNT</th><th>STATUS</th></tr>
  5. <?
  6. include("conn.php");
  7. mysql_select_db("account");
  8. $query = mysql_query("SELECT * FROM account WHERE status NOT LIKE 'OK' ORDER BY login DESC LIMIT 100");
  9.  
  10. $i=1;
  11. $num=mysql_num_rows($query);
  12.  
  13. while($i < $num){
  14.  
  15. $row=mysql_fetch_array($query);
  16. $name=$row["login"];
  17. $level=$row["status"];
  18.  
  19. if ($i>=4){
  20.  
  21. $pos=$i."<sup>th</sup>";
  22.  
  23. }elseif ($i==1){
  24.  
  25. $pos=$i."<sup>st</sup>";
  26.  
  27. }elseif ($i==2){
  28.  
  29. $pos=$i."<sup>nd</sup>";
  30.  
  31. }elseif ($i==3){
  32.  
  33. $pos=$i."<sup>rd</sup>";
  34.  
  35. }
  36.  
  37. ?>
  38. <tr><td><?=$pos?></td><td><?=$name?></td><td><?=$level?></td></tr>
  39. <?
  40.  
  41. $i++;
  42.  
  43. }
  44.  
  45. ?>
  46. </table>
RAW Paste Data