#1
  1. No Profile Picture
    Stefan Filipiuk
    Guest
    Devshed Newbie (0 - 499 posts)
    lo all

    I've a problem. I hope U can help me.

    I'll mak a Select on a TABLE and I'll order the rows and I'll limit the output.
    But I can't make ORDER BY and LIMIT x,y in one string.
    OR?

    Here an example:
    SELECT id, name from TABLE ORDER BY id LIMIT 0, 10

    But this string dosn't go...
    I hope U can help me...
    THX
  2. #2
  3. No Profile Picture
    rod k
    Guest
    Devshed Newbie (0 - 499 posts)
    There is nothing wrong with that query. What error is it giving you when you use it? Are you interfacing with mysql on the command line or thru a script?
  4. #3
  5. No Profile Picture
    Stefan Filipiuk
    Guest
    Devshed Newbie (0 - 499 posts)
    ups

    I've answer myself :P

    Sorry I've write the String correct here but not in the PHP source.

    I've write here:
    ... ORDER BY id LIMIT 0, 2;
    and in my script:
    ... LIMIT 0, 2 ORDER BY id;

    It's very embarrassingly for me.
    But thx for the fast reply.

IMN logo majestic logo threadwatch logo seochat tools logo