Php Mysql Question

Discussion in 'PHP' started by selen, Jan 6, 2010.

0
  1. #1
    Hello
    I want to select the last 700 users of my database. Now I want to ask if this is correct: order by ID ASC LIMIT 0,700
     
    selen, Jan 6, 2010 IP
  2. w3goodies

    w3goodies Member

    Messages:
    94
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    38
    #2
    No, you need to do this by ORDER BY ID DESC LIMIT 0, 700.
    ASC(Ascending) will not work for you, because you want to select the last 700 users, not the first 700 users right?
     
    w3goodies, Jan 6, 2010 IP
  3. selen

    selen Well-Known Member

    Messages:
    525
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    118
    #3
    Okay thanks a lot.
     
    selen, Jan 6, 2010 IP