i am wanting to build a leaderboard for my site for the members gamerscore on Xbox LIVE. I know how to fech from a MySQL database, etc but this is the hard bit.
So the users table in MySQL contains their gamertag and i want to pull that out for each user and then get there gamerscore from a xml external below i will show you how to do it for one user which i use on their profile pages but i want a top 100 and the only prblem is that i have over 5000 members.
So here it is:
$gamertag = $fetch['gamertag']; $xmlLocation = "http://xboxapi.duncanmackenzie.net/gamertag.ashx?GamerTag=".$gamertag; $Gamerinfo = simplexml_load_file($xmlLocation); echo "Gamerscore: ".$Gamerinfo->GamerScore;
Now i think this would maybe go into a loop of some sort? But thanks and please help if you can.