Left Quote    A clever person solves a problem. A wise person avoids it.
- Einstein    
Right Quote
[login] | [Register]
Forum Index » PHP and mySQL » Viewing Topic and Replies
Post Reply

        Viewing Topic: New users
  This user is offline  Genius
  Subject: "New users" Posted: @ 8:42 pm on Mar 11 2008   

Member #: 582
Rank: User - (77)
Since: 02/18/08
Posts: 76
From: kmmk

Ok, I came up with the idea of showing 5 new registered users on my site. I just don't know how to retrieve info from db. I got the total number f users part, but not the new ones. I got the registered date in my db, I think it will be helpful. So, someone please post the code for me.

PS: I bet bs0d knows this

Edited at 08:46:20 pm on 03/11/08

    Viewed: 4,260 Times | Reply to This | To top
  This user is offline  bs0d
  Subject: "re: New users" Posted: @ 10:33 pm on Mar 11 2008    

Member #: 1
Rank: Admin. - (1,506)
Since: 02/06/05
Posts: 600
From: USA

You could query the users table, ORDER BY time DESC LIMIT 5. That would pretty much do it I think.

-bs0d |

    Viewed: 4,251 Times | Reply to This | To top
Viewing Page: 1 of 1

1 |

You must be logged in to post on the forums. Login or Register

"" Copyright © 2002-2019; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank