RevCMS Script

[Glee]

I'm trying to created a script to get the newest users

<?php 
                                $getUserInfo = mysql_query("SELECT * FROM users WHERE account_created ORDER BY id LIMIT 1");
                                while ($userInfo= mysql_fetch_assoc($getUserInfo))
                                     {
                                echo '

But it still show me as Staff member even though I had 3 users registered today (test accounts)

Edit 2:

Trying to get this to get WHERE online = 1 aswell

<?php  
$getStaff = mysql_query("SELECT * FROM users WHERE rank <=5");  
$staffs = mysql_num_rows($getStaff);  
?>

[MentaL]

[asesinato]

Hey @Glee, the reason why you're only getting your username because in your syntax you're SELECTING * all rows in account_created with the ORDER limited being by 1, your username is at the top so it's returning your username. Here is a little script I just created, hope it helps

<?php
$getUserInfo = mysql_query("SELECT * from users ORDER by id DESC");
$showUserInfo = mysql_fetch_assoc($getUserInfo);
?>
<!-- Style whatever you like here, habblet container or whatever -->
<?php echo filter($showUserInfo['username']); ?>

- - - Updated - - -

For the second one, I don't quite understand what you mean.

[Liam]

Do you mean:

<?php  
$getStaff = mysql_query("SELECT * FROM 'users' WHERE rank <=5 AND 'online' = 1");  
$staffs = mysql_num_rows($getStaff);  
?>

If not, please elaborate.

[Kemyst]

@Glee If you're trying to get only staff members then the code would be something like this.

<?php$getTopStats = mysql_query("SELECT look,username from users WHERE rank > 5 ORDER BY id DESC LIMIT 1");while($topSpats = mysql_fetch_array($getTopStats)){echo '<tr><td width="50px"> </td>            <td width="20px">';  echo '<img src="http://www.habbo.fr/habbo-imaging/avatarimage?figure=' . $topSpats['look'] . '&size=lrg&direction=3&head_direction=3&gesture=sml&size=m" align="center"></td> <td width=195px" align="center"><a href="#"><b>'.$topSpats['username'].'</b></a>';echo '</td>           ';
}?>

While if you're trying to get hold of latest users registered script would be like

<?php$getTopStats = mysql_query("SELECT look,username from users ORDER BY id DESC LIMIT 1");while($topSpats = mysql_fetch_array($getTopStats)){echo '<tr><td width="50px"> </td>            <td width="20px">';  echo '<img src="http://www.habbo.fr/habbo-imaging/avatarimage?figure=' . $topSpats['look'] . '&size=lrg&direction=3&head_direction=3&gesture=sml&size=m" align="center"></td> <td width=195px" align="center"><a href="#"><b>'.$topSpats['username'].'</b></a>';echo '</td>           ';
}

[Glee]

@Glee If you're trying to get only staff members then the code would be something like this.

<?php$getTopStats = mysql_query("SELECT look,username from users WHERE rank > 5 ORDER BY id DESC LIMIT 1");while($topSpats = mysql_fetch_array($getTopStats)){echo '<tr><td width="50px"> </td>            <td width="20px">';  echo '<img src="http://www.habbo.fr/habbo-imaging/avatarimage?figure=' . $topSpats['look'] . '&size=lrg&direction=3&head_direction=3&gesture=sml&size=m" align="center"></td> <td width=195px" align="center"><a href="#"><b>'.$topSpats['username'].'</b></a>';echo '</td>           ';
}?>

While if you're trying to get hold of latest users registered script would be like

<?php$getTopStats = mysql_query("SELECT look,username from users ORDER BY id DESC LIMIT 1");while($topSpats = mysql_fetch_array($getTopStats)){echo '<tr><td width="50px"> </td>            <td width="20px">';  echo '<img src="http://www.habbo.fr/habbo-imaging/avatarimage?figure=' . $topSpats['look'] . '&size=lrg&direction=3&head_direction=3&gesture=sml&size=m" align="center"></td> <td width=195px" align="center"><a href="#"><b>'.$topSpats['username'].'</b></a>';echo '</td>           ';
}

Already been fixed Thank You Though