Help me with Gamesitescript!!!

Discussion in 'PHP' started by lightstarm2k, Dec 24, 2008.

0
  1. #1
    I want to change from order ASC/DESC by alphabetic on category page to order by latest games.

    Thanks
     
    lightstarm2k, Dec 24, 2008 IP
  2. sandstorm140

    sandstorm140 Peon

    Messages:
    80
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    you should will need to add a field with dates and time the game was added and then the sql part would be ".......ORDER BY date ASC".
    Or if you have IDs setup working correctly sort by IDs (which I wouldn't recommend).
     
    sandstorm140, Dec 24, 2008 IP
  3. lightstarm2k

    lightstarm2k Well-Known Member

    Messages:
    3,626
    Likes Received:
    89
    Best Answers:
    0
    Trophy Points:
    140
    #3
    I tried to order by IDs, but it doesn't work
    here is the original code of the GSS.

     
    lightstarm2k, Dec 24, 2008 IP
  4. planemaniac

    planemaniac Peon

    Messages:
    49
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    You would need a field which holds the date of the game, then you would "ORDER BY date ASC" on the SQL query. It's not that hard, but you would also have to update the script that puts the games into the database to include the date.
     
    planemaniac, Dec 24, 2008 IP