pagination issue

Discussion in 'PHP' started by dangys, Apr 11, 2008.

0
  1. #1
    If someone posts a solution, use the "Best Answer" link in their post to pick it as the best answer.
    dangys, Apr 11, 2008 IP
  2. dangys

    dangys Guest

    Best Answers:
    0
    #2
    still need help with this
     
    dangys, Apr 12, 2008 Set Best Answer IP
  3. BigJim21

    BigJim21 Peon

    Messages:
    14
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    well i am not sure i understand 100% but i think your talking about the post right if so you should use a oder by clause in you sql to pull them from newest to oldest order them by date desc and should fix it for you
     
    BigJim21, Apr 12, 2008 Set Best Answer IP
  4. dangys

    dangys Guest

    Best Answers:
    0
    #4
    dont quite follow.
     
    dangys, Apr 13, 2008 Set Best Answer IP
  5. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #5
    I can do this for u in $10

    if you are interested PM me

    Regards

    Alex
     
    kmap, Apr 13, 2008 Set Best Answer IP
  6. Oli3L

    Oli3L Active Member

    Messages:
    207
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    70
    #6
    in the SQL query (select ... ORDER BY id ..) try to put "ASC" or "DESC"

    mysql_query("Select * .... ORDER BY id DESC..");
    or:
    mysql_query("Select * .... ORDER BY id ASC..");

    i don't realy remember
     
    Oli3L, Apr 13, 2008 Set Best Answer IP
  7. Xtrm2Matt

    Xtrm2Matt Active Member

    Messages:
    129
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    58
    #7
    ASC and DESC is right :)

    ASC: oldest to newest
    DESC: newest to oldest
     
    Xtrm2Matt, Apr 13, 2008 Set Best Answer IP