MySQL Select Statement Help

I have a php page, with mysql select query. I'm calling up data from two table. My select statement; SELECT [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL] FROM `$table_games2`, `$table_games3` WHERE `category`='$catnum' AND games2.id=[login to view URL] GROUP BY [login to view URL] ORDER BY [login to view URL] I'm trying to call up the following data; id, name from games2 gamesid, game, gameset, round from games3 WHERE `category`='$catnum' AND games2.id=[login to view URL] Then, I want the results grouped by the [login to view URL] Ordered by [login to view URL] The problem? I don't know what to add, so that instead of it spitting out the FIRST entry made for each GROUPED thing, it spits out the LAST. EXAMPLE: say the result data was id ===== 1 2 3 but because I grouped it, it showed me id = 1 /// the first row entered. I want it to show me id = 3, the LAST row entered. How do I do that?