<solved>I need help on

[PakiGangsta]

Ok i am trying to add latest 10 members registered and get figure out how would i grab the infromation.

[trq]

You will need a timestamp in your database which needs to be updated when users join, then a simple query allong the lines of....

[code]
SELECT username FROM users ORDER BY timestamp DESC LIMIT 10;
[/code]

[PakiGangsta]

alright that works but only display one usernaem

[trq]

Post your code.

[PakiGangsta]

[code]
      $forumselect1="SELECT username FROM user ORDER BY regtime DESC LIMIT 10 ASC";
      $forumselect2=mysql_query($forumselect1);
        while($getuser3=mysql_fetch_array($forumselect2))
        {
echo "<br>$getuser3[username]<br>";
}[/code]

[trq]

[code=php:0]
$forumselect1="SELECT username FROM user ORDER BY regtime DESC LIMIT 10";
[/code]

PS; You really should check your query works before trying to use any results from it. Your app stands a good chance of falling appart otherwise.

[PakiGangsta]

thanks man solved problem