Witam,
Mam problem z modyfikacja poniższego zapytania

[SQL] pobierz, plaintext 
SELECT DISTINCT machines.name
              , locations.name
FROM
  game_locations
INNER JOIN game_location_machines
ON game_locations.id = game_location_machines.game_location_id
INNER JOIN locations
ON game_locations.location_id = locations.id
INNER JOIN machines
ON game_location_machines.machine_id = machines.id
WHERE
  game_locations.game_id = 36
ORDER BY
  locations.name
[SQL] pobierz, plaintext 

Chciałbym, żeby wszystkie maszyny byly w tablicy lokalizacji a nie pojedynczo

[HTML] pobierz, plaintext 
array(
	(int) 0 => array(
		'machines' => array(
			'name' => 's3'
		),
		'locations' => array(
			'name' => 'DE - HĂźrth'
		)
	),
	(int) 1 => array(
		'machines' => array(
			'name' => 's4'
		),
		'locations' => array(
			'name' => 'FR - OVH ROUBAIX 1'
		)
	),
	(int) 2 => array(
		'machines' => array(
			'name' => 's2'
		),
		'locations' => array(
			'name' => 'PL - ATMAN Warszawa
'
		)
	),
	(int) 3 => array(
		'machines' => array(
			'name' => 's1'
		),
		'locations' => array(
			'name' => 'PL - ATMAN Warszawa
'
		)
	)
)
[HTML] pobierz, plaintext