All pastes #184827 Raw Edit

Something

public php v1 · immutable
#184827 ·published 2006-09-28 10:13 UTC
rendered paste body
exmaple of database:statisticsentry_id   player_id  entry_tc_age1          1          102          2          123          1          94          1          485          3          12playerplayer_id  player_name1          john2          bob3          billWhat i want returned:entry_id  player_name  entry_tc_age5          bill        124          john        482          bob         12SELECT DISTINCT player_id,entry_date,entry_tc_age,entry_idFROM statisticsGROUP BY player_idORDER BY entry_id DESCReturns:entry_id  player_name  entry_tc_age5          bill        122          bob         121          john        10