Results 1 to 8 of 8
  1. #1
    JoeComins Guest

    Default Quick Coding Thingy-ma-jiggy

    I would like a table, with the headings:
    Name
    Played
    Won
    Lost
    Points

    Simple eh?
    Well, I want them to be able to be sorted assending and decending with the arrows at the top to sort them, such as:
    http://csstats.scmgames.net/hlstats....clans&game=css

    I also need it to have an admin panel so that the guy on the site only has to add a name to add a user, or just update the played, won, etc

    If theres one somewere on the internet, tell me

    Thanks

  2. #2
    Join Date
    Jun 2005
    Posts
    4,795
    Tokens
    0

    Latest Awards:

    Default

    Install hlstatsx on your server?

  3. #3
    JoeComins Guest

    Default

    Its not for a server. It because I want a table saying the amount of games each member has played, how many won, lost, and the points they get for winning/loosing/drawing etc

  4. #4
    JoeComins Guest

    Default

    OK Then.

    Whats the code to sort by assending/dessending.

    If someone could make me a quick table with the sort options already included in PHP, I would be greatful.

  5. #5
    Join Date
    Nov 2005
    Posts
    807
    Tokens
    1,335

    Latest Awards:

    Default

    for mysql its:
    PHP Code:
    $query mysql_query("SELECT * FROM stats ORDER BY id DESC"); 
    or
    PHP Code:
    $query mysql_query("SELECT * FROM stats"); 
    to make it ascend.

  6. #6
    Join Date
    Nov 2005
    Posts
    807
    Tokens
    1,335

    Latest Awards:

    Default

    for mysql its:
    PHP Code:
    $query mysql_query("SELECT * FROM stats ORDER BY id DESC"); 
    or
    PHP Code:
    $query mysql_query("SELECT * FROM stats ORDER BY id"); 
    to make it ascend.

  7. #7
    Join Date
    Feb 2006
    Location
    Coventry
    Posts
    2,096
    Tokens
    0

    Latest Awards:

    Default

    PHP Code:

    SELECT FROM table ORDER BY ASC 

  8. #8
    JoeComins Guest

    Default

    I did it myself earlier using JavaScript

Members who have read this thread: 0

There are no members to list at the moment.

Posting Permissions

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