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

    Latest Awards:

    Default Sql help! PLease!!

    right on my affiliates script how can i show all the affiliates after a certain id number? the sql query right now is

    PHP Code:
    $result mysql_query("SELECT * FROM affiliates ORDER BY total DESC"); // makes a query to database to table "affiliates" and orders it by total descending

    while ($row mysql_fetch_object($result)) { // while loop While you are connected to the database do this... 
    how can i modify it so say, i only want to show all the affiliates after the affiliate id 4? any help anybody?
    *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
    Sawley
    Posts
    771
    Tokens
    1,631
    Habbo
    T0X!C-uk

    Latest Awards:

    Default

    try putting a 4 where it says total

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

    Latest Awards:

    Default

    that just makes the one with the id 4 go at the end!
    *Image Removed


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

Posting Permissions

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