Phoenix User Stats Page PHP!

[jamieturner]

Hello I want a page like Habboons Home.cfm page

With the stats like..

Time Online ( TOTAL HOURS )
Pixels ( AMOUNT )
Respects ( AMOUNT )
Room Visits ( AMOUNT )
Gifts Given ( AMOUNT )
Gifts Recieved ( AMOUNT )
Achievement Score ( AMOUNT )

Image of Habboons: Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting

Can anyone code me this for Phoenix PHP.

Thanks.

[MentaL]

[Sjoerdj1]

I'm working on it!

[jamieturner]

Thanks mate.

---------- Post added at 05:08 AM ---------- Previous post was at 04:40 AM ----------

How long do you think you will be?

[</Meap>]

basically change around some sql and have it like
SELECT from user_stats 'OnlineTime' or something like that
Im not pro with SQL

[jamieturner]

that don't work , ive tried it already just has bare errors like.

[brendan90]

can you upload please i need it 2

[brendan90]

here you go

<?php
            $userq = mysql_query("SELECT * FROM user_stats");
            while($user = mysql_fetch_array($userq))
            {
                ?>
                <div class="StaffBox">
                    
                    <div class="UsersCreated"><strong>Time Online:</strong> <?php echo $user['OnlineTime']; ?></div>
                    <div class="UsersCreated"><strong>Room Visits:</strong> <?php echo $user['RoomVisits']; ?></div>
                    <div class="UsersCreated"><strong>Respects:</strong> <?php echo $user['RespectGiven']; ?></div>
                    <div class="UsersCreated"><strong>Gifts Given:</strong> <?php echo $user['GiftsGiven']; ?></div>
                    <div class="UsersCreated"><strong>Gifts Recieved:</strong> <?php echo $user['GiftsReceived']; ?></div>
                    <div class="UsersCreated"><strong>Achievement Score:</strong> <?php echo $user['AchievementScore']; ?></div>
                   
                    
                </div>
            <?php
            }
            ?>
</div>

[Glee]

here you go

<?php
            $userq = mysql_query("SELECT * FROM user_stats");
            while($user = mysql_fetch_array($userq))
            {
                ?>
                <div class="StaffBox">
                    
                    <div class="UsersCreated"><strong>Time Online:</strong> <?php echo $user['OnlineTime']; ?></div>
                    <div class="UsersCreated"><strong>Room Visits:</strong> <?php echo $user['RoomVisits']; ?></div>
                    <div class="UsersCreated"><strong>Respects:</strong> <?php echo $user['RespectGiven']; ?></div>
                    <div class="UsersCreated"><strong>Gifts Given:</strong> <?php echo $user['GiftsGiven']; ?></div>
                    <div class="UsersCreated"><strong>Gifts Recieved:</strong> <?php echo $user['GiftsReceived']; ?></div>
                    <div class="UsersCreated"><strong>Achievement Score:</strong> <?php echo $user['AchievementScore']; ?></div>
                   
                    
                </div>
            <?php
            }
            ?>
</div>

Don't work 100% cause it will show all the users online time -.-

[jamieturner]

can someone make it so its show user id as 1 not all the hotel users registered -.-?

---------- Post added at 12:51 PM ---------- Previous post was at 12:48 PM ----------

Thanks if any one can help