| | |
| Stránka: 1 z 1
| [ Príspevkov: 11 ] | |
Autor | Správa |
---|
Registrovaný: 19.12.09 Prihlásený: 01.02.11 Príspevky: 10 Témy: 1 | Napísal VireL: 29.12.2009 16:35 | |
|
Ahojte, po dlhsom case som zacal robit jeden SQL script ale potrebujem vybrat z jednej tabulky dva krat nieco ine ale mne sa to dajak nedary
Moj zapis vyzera takto
Kód: $zapas = mysql_fetch_array(mysql_query("SELECT t1.*, t2.*, t3.* FROM ".DB_ZAPASY." as t1 INNER JOIN ".DB_TEAMY." as t2 LEFT JOIN ".DB_TEAMY." as t3 WHERE t1.zapas_id='".$_GET['id']."' AND t2.team_id=t1.zapas_klan AND t3.team_meno=t1.zapas_super LIMIT 1"));
tabulka teamy vyzera takto Kód: =team_id =team_meno =team_liga =team_cl =team_hraci =team_nastenka =team_body =team_stav a tabulka zapasov nasledovne Kód: =zapas_id =zapas_klan =zapas_liga =zapas_super =zapas_stav =zapas_body_k =zapas_body_s =zapas_mapa
Za pomoc dakujem
|
|
Registrovaný: 09.07.08 Prihlásený: 17.01.15 Príspevky: 1585 Témy: 96 |
AND t3.team_meno=t1.zapas_super
zameň za
AND t3.team_id=t1.zapas_super
Teda ak som správne pochopil problém
_________________ neříkejte, že něco nejde udělat, protože se vždycky najde nějaký blbec, co neví, že to nejde – a udělá to! |
|
Registrovaný: 19.12.09 Prihlásený: 01.02.11 Príspevky: 10 Témy: 1 | Napísal autor témy VireL: 29.12.2009 18:39 | |
|
Hops sry to som zle napisal ale aj tak mi to nejde
A problem si nepochopil spravne
Akoze chcem vybrat 2 teamy naraz a neviem ako by som zmenil aby 1. team mal meno napr. team_meno_k a 2. team team_meno_s
oprava
Kód: $zapas = mysql_fetch_array(mysql_query("SELECT t1.*, t2.*, t3.* FROM ".DB_ZAPASY." as t1 INNER JOIN ".DB_TEAMY." as t2 LEFT JOIN ".DB_TEAMY." as t3 WHERE t1.zapas_id='".$_GET['id']."' AND t2.team_id=t1.zapas_klan AND t3.team_id=t1.zapas_super LIMIT 1"));
|
|
Registrovaný: 30.05.06 Prihlásený: 08.10.14 Príspevky: 1756 Témy: 35 Bydlisko: BA - WESTSIDE | Napísal p360t: 29.12.2009 18:52 | |
|
Ak som ťa dobre pochopil, tak chceš toto: Kód: SELECT z.zapas_id, k.team_id, k.team_meno, s.team_id, s.team_meno, z.zapas_liga, z.zapas_stav, z.zapas_body_k, z.zapas_body_s, z.zapas_mapa FROM ".DB_ZAPASY." AS z LEFT JOIN ".DB_TEAMY." AS k ON (k.team_id = z.zapas_klan) LEFT JOIN ".DB_TEAMY." AS s ON (s.team_id = z.zapas_super) WHERE t1.zapas_id = '".$_GET['id']."' LIMIT 1 Odporúčam nepoužívať pri výpise stĺpcov hviezdičky, ale pekne si všetko vymenovať. Pri joinoch môžeš hneď použiť podmienku ON, malo by to ušetriť trochu výpočtov (ak si to ešte dobre pamätám zo školy ). A aliasy nepoužívaj také všeobecné, ale také, čo naozaj niečo znamenajú (aspoň iniciálom: z - zápas, k - klan, s - súper).
_________________
A. S. Tanenbaum píše: The terms LF, MF, and HF refer to low, medium, and high frequency, respectively. Clearly, when the names were assigned, nobody expected to go above 10 MHz, so the higher bands were later named the Very, Ultra, Super, Extremely, and Tremendously High Frequency bands. Beyond that there are no names, but Incredibly, Astonishingly, and Prodigiously high frequency (IHF, AHF, and PHF) would sound nice. |
|
Registrovaný: 19.12.09 Prihlásený: 01.02.11 Príspevky: 10 Témy: 1 | Napísal autor témy VireL: 29.12.2009 18:59 | |
|
Viem * môže pri veľa pripojeniach zhodiť server, o ON viem a čo sa týka výberu nehodí mi error ale nevypíše mi to
Cele to teraz vyzerá nejak takto
Kód: $zapas = mysql_fetch_array(dbquery("SELECT z.zapas_id, k.team_id, k.team_meno, s.team_id, s.team_meno, z.zapas_liga, z.zapas_stav, z.zapas_body_k, z.zapas_body_s, z.zapas_mapa FROM ".DB_ZAPASY." AS z LEFT JOIN ".DB_TEAMY." AS k ON (k.team_id = z.zapas_klan) LEFT JOIN ".DB_TEAMY." AS s ON (s.team_id = z.zapas_super) WHERE z.zapas_id = '".$_GET['id']."' LIMIT 1")); //$super = mysql_fetch_array(mysql_query("SELECT * FROM ".DB_TEAMY." WHERE team_id='".$zapas['zapas_super']."' LIMIT 1")); opentable($locale['l_11'].$zapas['zapas_id']); echo "<table border='1' width='100%' style='border-collapse:collapse'>"; echo "<tr style='height:20px'><td colspan='2'><strong><span style='font-size:13px'>".$locale['l_12']."</span></strong></td></tr>"; echo "<tr style='height:20px'><td><strong>".$locale['l_13']."</strong></td> <td style='padding-left:3px' align='left'>".$zapas['zapas_mapa']."</td></tr>"; echo "<tr style='height:20px'><td><strong>".$locale['l_14']."</strong></td> <td style='padding-left:3px' align='left'>".$zapas['team_meno']."</td></tr>"; echo "<tr style='height:20px'><td><strong>".$locale['l_15']."</strong></td> <td style='padding-left:3px' align='left'>".$zapas['team_meno']."</td></tr>"; echo "<tr style='height:20px'><td><strong>".$locale['l_16']."</strong></td> <td style='padding-left:3px' align='left'>".$zapas['zapas_body_k']."</td></tr>"; echo "<tr style='height:20px'><td><strong>".$locale['l_17']."</strong></td> <td style='padding-left:3px' align='left'>".$zapas['zapas_body_s']."</td></tr>"; echo "</table>";
A screen
http://imghost.sk/files/12b76t78q31sdioynlnb.png
|
|
Registrovaný: 30.05.06 Prihlásený: 08.10.14 Príspevky: 1756 Témy: 35 Bydlisko: BA - WESTSIDE | Napísal p360t: 29.12.2009 19:05 | |
|
Čo vypíše toto: Kód: $zapas = mysql_fetch_assoc(dbquery("SELECT z.zapas_id, k.team_id, k.team_meno, s.team_id, s.team_meno, z.zapas_liga, z.zapas_stav, z.zapas_body_k, z.zapas_body_s, z.zapas_mapa FROM ".DB_ZAPASY." AS z LEFT JOIN ".DB_TEAMY." AS k ON (k.team_id = z.zapas_klan) LEFT JOIN ".DB_TEAMY." AS s ON (s.team_id = z.zapas_super) WHERE z.zapas_id = '".$_GET['id']."' LIMIT 1")); echo "<pre>".print_r($zapas)."</pre>";
_________________
A. S. Tanenbaum píše: The terms LF, MF, and HF refer to low, medium, and high frequency, respectively. Clearly, when the names were assigned, nobody expected to go above 10 MHz, so the higher bands were later named the Very, Ultra, Super, Extremely, and Tremendously High Frequency bands. Beyond that there are no names, but Incredibly, Astonishingly, and Prodigiously high frequency (IHF, AHF, and PHF) would sound nice. |
|
Registrovaný: 19.12.09 Prihlásený: 01.02.11 Príspevky: 10 Témy: 1 | Napísal autor témy VireL: 29.12.2009 19:09 | |
|
Kód: Array ( [zapas_id] => 1 [team_id] => [team_meno] => [zapas_liga] => 1 [zapas_stav] => 0 [zapas_body_k] => 12 [zapas_body_s] => 4 [zapas_mapa] => de_lama )
|
|
Registrovaný: 30.05.06 Prihlásený: 08.10.14 Príspevky: 1756 Témy: 35 Bydlisko: BA - WESTSIDE | Napísal p360t: 29.12.2009 19:14 | |
|
Ok, toto by už mohlo ísť: Kód: $zapas = mysql_fetch_assoc(dbquery("SELECT z.zapas_id, k.team_id AS klan_id, k.team_meno AS klan_meno, s.team_id AS super_id, s.team_meno AS super_meno, z.zapas_liga, z.zapas_stav, z.zapas_body_k, z.zapas_body_s, z.zapas_mapa FROM ".DB_ZAPASY." AS z LEFT JOIN ".DB_TEAMY." AS k ON (k.team_id = z.zapas_klan) LEFT JOIN ".DB_TEAMY." AS s ON (s.team_id = z.zapas_super) WHERE z.zapas_id = '".$_GET['id']."' LIMIT 1")); echo "<pre>".print_r($zapas)."</pre>";
_________________
A. S. Tanenbaum píše: The terms LF, MF, and HF refer to low, medium, and high frequency, respectively. Clearly, when the names were assigned, nobody expected to go above 10 MHz, so the higher bands were later named the Very, Ultra, Super, Extremely, and Tremendously High Frequency bands. Beyond that there are no names, but Incredibly, Astonishingly, and Prodigiously high frequency (IHF, AHF, and PHF) would sound nice. |
|
Registrovaný: 19.12.09 Prihlásený: 01.02.11 Príspevky: 10 Témy: 1 | Napísal autor témy VireL: 29.12.2009 19:18 | |
|
Kód: Array ( [zapas_id] => 1 [klan_id] => 1 [klan_meno] => VireL team [super_id] => [super_meno] => [zapas_liga] => 1 [zapas_stav] => 0 [zapas_body_k] => 12 [zapas_body_s] => 4 [zapas_mapa] => de_lama )
Ja som z toho jeleň xD
Asi to nakoniec predsa nechám na 2 výbery.
|
|
Registrovaný: 30.05.06 Prihlásený: 08.10.14 Príspevky: 1756 Témy: 35 Bydlisko: BA - WESTSIDE | Napísal p360t: 29.12.2009 19:23 | |
|
A určite v tej tabuľke existuje ten súper?
_________________
A. S. Tanenbaum píše: The terms LF, MF, and HF refer to low, medium, and high frequency, respectively. Clearly, when the names were assigned, nobody expected to go above 10 MHz, so the higher bands were later named the Very, Ultra, Super, Extremely, and Tremendously High Frequency bands. Beyond that there are no names, but Incredibly, Astonishingly, and Prodigiously high frequency (IHF, AHF, and PHF) would sound nice. |
|
Registrovaný: 19.12.09 Prihlásený: 01.02.11 Príspevky: 10 Témy: 1 | Napísal autor témy VireL: 29.12.2009 19:28 | |
|
Lol bóže ukameňujte ma Som tu modifikáciu inštaloval nanovo takže nebol Sory. Ďakujem(kde bývaš? Pozývam na pivo).
Poprosím LOCK
|
|
| Stránka: 1 z 1
| [ Príspevkov: 11 ] | |
| Nemôžete zakladať nové témy v tomto fóre Nemôžete odpovedať na témy v tomto fóre Nemôžete upravovať svoje príspevky v tomto fóre Nemôžete mazať svoje príspevky v tomto fóre
|
|