[SQL] Zapytanie mysql Opcje

[Kahras]

Struktura:

[SQL] pobierz, plaintext 
CREATE TABLE IF NOT EXISTS `bug_tracker` (
  `id` INT  AUTO_INCREMENT,
  `player_id` INT NOT NULL,
  `description` text ,
  `pos` text ,
  `ip` INT UNSIGNED NOT NULL DEFAULT 0,
  `date` BIGINT UNSIGNED NOT NULL,
  FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB;
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT `id`, `player_id`, `description`, `pos`, `ip`, `date` FROM `bug_tracker`;
[SQL] pobierz, plaintext 

Jak po player_id pobrac wartosc z kolumny name z tabeli players ?

Bo chce sobie wyciagnac z..

[PHP] pobierz, plaintext 
foreach($SQL->query('SELECT `id`, `player_id`, `description`, `pos`, `ip`, `date` FROM `bug_tracker`;') as $info)
[PHP] pobierz, plaintext 

[nospor]

Normalnie, LEFT JOIN

[Kahras]

Normalnie, LEFT JOIN

[SQL] pobierz, plaintext 
SELECT `id`, `player_id`, `description`, `pos`, `ip`, `date` FROM `bug_tracker` LEFT JOIN `players` ON `bug_tracker.player_id` = `players.id`
[SQL] pobierz, plaintext 

:/
gdzie blad?

[mmmmmmm]

Kod

SELECT `id`, `player_id`, `description`, `pos`, `ip`, `date` FROM `bug_tracker` LEFT JOIN `players` ON `bug_tracker`.`player_id` = `players`.`id`

To nadal nie będzie działać (ja wiem, czemu), ale naucz się czytać komunikaty o błędach

[Boshi]

mmmmm chciałeś chyba napisać, naucz się składni Left Joina (IMG:style_emoticons/default/smile.gif)