exmaple of database: statistics entry_id player_id entry_tc_age 1 1 10 2 2 12 3 1 9 4 1 48 5 3 12 player player_id player_name 1 john 2 bob 3 bill What i want returned: entry_id player_name entry_tc_age 5 bill 12 4 john 48 2 bob 12 $display_unique = "SELECT statistics.*, player.player_name FROM statistics, player WHERE statistics.player_id = player.player_id ORDER BY statistics.entry_id DESC"; $query_unique=@mysql_query($display_unique,$dbac); if (!$query_unique) { echo 'Error'; }; while ($result_unique[] = mysql_fetch_array($query_unique)); array_pop($result_unique); $result_unique = array_unique(result_unique); foreach ($result_unique as $value) { echo $value['entry_id']; echo $value['player_name']; echo $value['entry_tc_age']; }