Need help !! Mysql - Will add to rep if you help me out ^^

Discussion in 'PHP' started by Dakuipje, Oct 23, 2007.

  1. #1
    Im having trouble limiting results with mysql:


    My query:
    SELECT * FROM uploads ORDER BY CAST(views AS UNSIGNED) DESC, views LIMIT 70, 80
    PHP:
    The problem is that instead of the results between 70 and 80 I get the first 80. So instead of 10 results it gives me 80 results.



    Whats the problem ??
    (will add to rep if you help me out)
     
    Dakuipje, Oct 23, 2007 IP
  2. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #2
    Limit 70, 10
     
    nico_swd, Oct 23, 2007 IP
  3. Dakuipje

    Dakuipje Peon

    Messages:
    931
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Lol, damn clever ^^


    1 prob, last rep I gave out was to you, get an error telling me to spread out rep to other first before I can add to yours......
     
    Dakuipje, Oct 23, 2007 IP
  4. SharkSpace

    SharkSpace Peon

    Messages:
    431
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #4
    You can give one to me first since I was just about to post the answer :) j/k
     
    SharkSpace, Oct 23, 2007 IP
  5. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #5
    Lol, no worries. I'll live without it. :)
     
    nico_swd, Oct 23, 2007 IP