Results 1 to 3 of 3

Thread: Mysql Help!!

  1. #1
    Join Date
    Aug 2004
    Location
    Over there. ^_^
    Posts
    1,100
    Tokens
    0

    Latest Awards:

    Default Mysql Help!!

    right on my page which shows all of the affiliates, how do i show all of the affiliates after a certain id say i wanted to show only the affiliates after the id 5 how do i edit the mysql query so it does that?

    PHP Code:
    $result mysql_query("SELECT * FROM affiliates ORDER BY id LIMIT 5"); 
    Last edited by xEnigmA; 09-08-2005 at 02:11 PM.
    *Image Removed


    Ahemm.. How exactly was my sig innapropriate?
    Goddamit i hate this forum :@
    I RESIGN FROM GRAPHICS DESIGNER :@ :@ :@

  2. #2
    Join Date
    Aug 2004
    Location
    Over there. ^_^
    Posts
    1,100
    Tokens
    0

    Latest Awards:

    Default

    Ignored yet again!! <(*_*<)

    ^ ^ ^ Bump!
    *Image Removed


    Ahemm.. How exactly was my sig innapropriate?
    Goddamit i hate this forum :@
    I RESIGN FROM GRAPHICS DESIGNER :@ :@ :@

  3. #3
    Join Date
    Aug 2004
    Location
    UK
    Posts
    11,283
    Tokens
    2,031

    Latest Awards:

    Default

    you set it out like this

    LIMIT 5 , 30

    wich will show 30 results after the 5th one

    so
    $result = mysql_query("SELECT * FROM affiliates ORDER BY id LIMIT 5 , 10");

    wich should show 5 results after the 10th one, just sort of follow on with that basis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •