[MySQL] Problem z ułożeniem zapytania Opcje

[lekosm2]

Witajcie. Potrzebuję pomocy ze złożeniem zapytania, nie wiem jak zrobić by wyświetlało wszystkie wpisy kar, które są przypisane do moich postaci.

Struktura postaci:

[SQL] pobierz, plaintext 
CREATE TABLE `rp_characters` (
  `char_uid` int(11) NOT NULL,
  `char_gid` int(11) NOT NULL,
  `char_crew_level` int(5) NOT NULL DEFAULT '0',
  `char_name` varchar(24) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
  `char_hours` mediumint(6) NOT NULL DEFAULT '0',
  `char_minutes` smallint(2) NOT NULL DEFAULT '0',
  `char_cash` int(11) NOT NULL DEFAULT '800',
  `char_bankcash` int(11) NOT NULL DEFAULT '0',
  `char_banknumb` int(11) NOT NULL DEFAULT '0',
  `char_skin` smallint(3) NOT NULL,
  `char_health` float NOT NULL DEFAULT '100',
  `char_sex` tinyint(1) NOT NULL,
  `char_birth` mediumint(4) NOT NULL,
  `char_posx` float NOT NULL DEFAULT '0',
  `char_posy` float NOT NULL DEFAULT '0',
  `char_posz` float NOT NULL DEFAULT '0',
  `char_posa` float NOT NULL DEFAULT '0',
  `char_world` int(11) NOT NULL DEFAULT '0',
  `char_interior` int(11) NOT NULL DEFAULT '0',
  `char_quittime` int(15) NOT NULL,
  `char_block` smallint(2) NOT NULL DEFAULT '0',
  `char_crash` int(11) NOT NULL DEFAULT '0',
  `char_arrest` int(11) NOT NULL DEFAULT '0',
  `char_strength` mediumint(5) NOT NULL DEFAULT '3500',
  `char_dependence` float NOT NULL DEFAULT '0',
  `char_drunk` int(5) NOT NULL,
  `char_bw` mediumint(6) NOT NULL,
  `char_aj` mediumint(6) NOT NULL,
  `char_house` int(11) NOT NULL DEFAULT '0',
  `char_job` tinyint(1) NOT NULL DEFAULT '0',
  `char_documents` tinyint(1) NOT NULL DEFAULT '0',
  `char_achievements` int(11) NOT NULL DEFAULT '0',
  `char_talkstyle` tinyint(1) NOT NULL DEFAULT '0',
  `char_walkstyle` smallint(3) NOT NULL DEFAULT '0',
  `char_fightstyle` tinyint(2) NOT NULL DEFAULT '15',
  `char_ooc` tinyint(1) NOT NULL DEFAULT '1',
  `char_lastskin` smallint(3) NOT NULL DEFAULT '0',
  `char_mileage` float NOT NULL DEFAULT '0',
  `char_desc` varchar(128) NOT NULL,
  `char_payday` tinyint(1) NOT NULL DEFAULT '0',
  `char_visible` int(11) NOT NULL,
  `char_rename` int(11) NOT NULL DEFAULT '0',
  `char_door` int(10) NOT NULL,
  `char_login` int(11) NOT NULL DEFAULT '0',
  `char_online` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[SQL] pobierz, plaintext 

Struktura kar:

[SQL] pobierz, plaintext 
CREATE TABLE `rp_penalties` (
  `penalty_uid` int(11) NOT NULL,
  `penalty_owner` int(11) NOT NULL,
  `penalty_giver` int(11) NOT NULL,
  `penalty_type` tinyint(2) NOT NULL,
  `penalty_extraid` tinyint(2) NOT NULL,
  `penalty_reason` varchar(128) NOT NULL,
  `penalty_date` int(10) NOT NULL,
  `penalty_end` int(10) NOT NULL,
  `penalty_deactivate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[SQL] pobierz, plaintext 

ID profilu użytkownika jest przechowywane w zmiennej: $member['member_id']

UID postaci w tabeli rp_penalties jest zapisywane do kolumny penalty_owner

Próbowałem to zrobić w następujący sposób, ale nie działa jak powinno.

[SQL] pobierz, plaintext 
SELECT penalty_owner, penalty_giver, penalty_type, penalty_extraid, penalty_reason, penalty_date, penalty_end, penalty_deactivate, char_name FROM rp_penalties, rp_characters WHERE `penalty_owner` = (SELECT char_uid FROM rp_characters WHERE char_gid = '.$member[member_id].')
[SQL] pobierz, plaintext 

Jest ktoś w stanie pomóc?

Z góry dziękuję.

[itype88]

[SQL] pobierz, plaintext 
SELECT penalty_owner, penalty_giver, penalty_type, penalty_extraid, penalty_reason, penalty_date, penalty_end, penalty_deactivate, char_name FROM rp_penalties JOIN rp_characters ON rp_characters.char_uid = rp_penalties.penalty_owner WHERE `penalty_owner` = (SELECT char_uid FROM rp_characters WHERE char_gid = '.$member[member_id].')
[SQL] pobierz, plaintext 

trochę na sucho, a i temat nie do końca o tej porze rozumiem. sprawdź, czy działa :E