Left Quote    Knowledge speaks, but wisdom listens.
- Jimi Hendrix    
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: 5,214 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,510)
Since: 02/06/05
Posts: 604
From: USA

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

-bs0d |

    Viewed: 5,205 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-2021; All rights lefted, all lefts righted.
Privacy Policy