Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. mysql_select_db("tbc_char") or die(mysql_error());
  2.  
  3. $q = mysql_query("SELECT arena_team.arenateamid, arena_team.name, arena_team_stats.rating
  4. FROM arena_team, arena_team_stats
  5. WHERE arena_team.type = 2 AND arena_team.arenateamid = arena_team_stats.arenateamid ORDER BY arena_team_stats.rating DESC LIMIT 5");
  6. $row = mysql_fetch_assoc($q);
  7.  
  8. echo"
  9. <ol>
  10. <li>$row[name] $row[rating]</li>
  11. </ol>
  12. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement