How to list rows except first one ?

Discussion in 'PHP' started by meannn, May 17, 2010.

0
  1. #1
    Hello, how can I list rows except first one ? Thank you.

    $query="select * from dle_post where $q ORDER BY id DESC limit 10";
     
    Last edited: May 17, 2010
    meannn, May 17, 2010 IP
  2. lorkan

    lorkan Peon

    Messages:
    20
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    what exactly do you mean?
    are you talking about sql database outputs like $row['field_name']?
     
    lorkan, May 17, 2010 IP
  3. meannn

    meannn Peon

    Messages:
    255
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yes... I want to show latest results but except the first one.
     
    meannn, May 17, 2010 IP
  4. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    #4 
    $query="select * from dle_post where $q ORDER BY id DESC limit 1,9";
    PHP:
    :cool:
     
    koko5, May 18, 2010 IP