Stats in me.php

[Tequiro]

I'm trying to rip this:

But I end up getting this:

It keeps adding the place, username & diamonds but I only want that at the top.
I also don't know how to make it automatically count from 1 to 10.

My code is: <div id="container"> <div id="content" style="posit - Pastebin.com
Example site: Just a moment...

 

[Vaulient]

vip_points? or is it supposed to be credits? What exactly does diamanten stand for?

 

[asesinato]

http://pastebin.com/jmV0vBcZ Enjoy

 

[Vaulient]

nvm , here's the fix

<div id="container">
                <div id="content" style="position: relative" class="clearfix">
                    <div id="column1" class="column">
                        <div class="habblet-container ">
                            <div class="cbb clearfix darkred ">
                                <h2 class="title">Top 10 Rijkste Habbo's in Diamanten</h2>
                                <table cellpadding="4" cellspacing="0" width="100%">
                                    <tr>
                                        <td class="tablesubheader" align="center"><b>Plaats</b></td>
                                        <td class="tablesubheader" align="center"><b>Habbonaam</b></td>
                                        <td class="tablesubheader" align="center"><b>Diamanten</b></td>
                                    </tr>

                                    <tr>
                                        <?php
                                        $count = 1;

                                        $users_a = mysql_query("SELECT * FROM users ORDER BY vip_points DESC LIMIT 10");
                                        while($users = mysql_fetch_assoc($users_a)){
                                        $row = mysql_fetch_assoc($row = mysql_query("SELECT * FROM users WHERE id = '".$users['id']."' LIMIT 10"));


                                        ?>
                                    <tr>
                                        <td class="tablerow1" align="center"><?php echo $count; ?></td>
                                        <td class="tablerow2" align="center"><a href="home/<?php echo $row['username']; ?>"><?php echo $row['username']; ?></td>
                                        <td class="tablerow3" align="center"><?php echo $users['vip_points']; ?></td>

                                    </tr>

                                    <?php $count++; } ?>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

 

[Tequiro]

Thank you both, works perfect!