Discover Habbo's history
Treat yourself with a Secret Santa gift.... of a random Wiki page for you to start exploring Habbo's history!
Happy holidays!
Celebrate with us at Habbox on the hotel, on our Forum and right here!
Join Habbox!
One of us! One of us! Click here to see the roles you could take as part of the Habbox community!


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
  •