I need help with my site

Discussion in 'Programming' started by xtera, Jun 10, 2009.

0
  1. #1
    Hi,

    I need to show 10 latest member name and state that join the system on the site bar. Anyone can help? site: flexireload.com

    Thanks
     
    xtera, Jun 10, 2009 IP
  2. hanx

    hanx Peon

    Messages:
    72
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    It is working with a database right?

    You can get this down with some SQL help. first get the members list in the order they got register (You can do that with a select statement) after that extract the top 10 values using (Select Top 10 * ......) and then print it on the website like in a table.
     
    hanx, Jun 11, 2009 IP
  3. Free Born John

    Free Born John Guest

    Messages:
    111
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    assuming you have an auto incremented id field on your table - if not add one.

    select top 10 * from table order by id desc
     
    Free Born John, Jun 11, 2009 IP