| Autor | Zpráva | ||
|---|---|---|---|
| pito Profil |
#1 · Zasláno: 18. 9. 2008, 23:48:39
Jak to zmenim do php kodu
SELECT tymy.nazev AS tymA, ( SELECT nazev FROM tymy WHERE tymy.id = zapasy.id_tymB ) AS tymB, tip.tip AS tip FROM tip INNER JOIN zapasy ON tip.id_zapas = zapasy.id INNER JOIN tymy ON zapasy.id_tymA = tymy.id WHERE tip.id_uzivatel =1 ORDER BY tip.id_tip DESC |
||
| Sicario Profil * |
#2 · Zasláno: 19. 9. 2008, 00:12:05
$result = mysql_query("SELECT ..."); |
||
| pito Profil |
#3 · Zasláno: 19. 9. 2008, 00:17:11
mam to takhle a nic mi to neukazuje
<?
require "db.php";
$result = mysql_query ('SELECT tymy.nazev AS tymA, ('SELECT nazev FROM tymy WHERE tymy.id = zapasy.id_tymB') AS tymB, tip.tip AS tip FROM tip'
. ' INNER JOIN zapasy ON tip.id_zapas = zapasy.id'
. ' INNER JOIN tymy ON zapasy.id_tymA = tymy.id'
. ' WHERE tip.id_uzivatel =1 '
. ' ORDER BY tip.id_tip DESC');
while($zaznam = mysql_fetch_array( $result )) {
echo $zaznam['tymA']
echo $zaznam['tymB']
echo $zaznam['tip']
}
?> |
||
| Sicario Profil * |
#4 · Zasláno: 19. 9. 2008, 00:30:16
Tak minimalne to musi hazet nejakou chybu protoze na radku $result = mysql_query ('SELECT tymy.nazev.... mas navic par uvozovek.
Po provedeni dotazu si nech vypsat chybova hlaseni SQL (jsou-li nejaka) pomoci echo mysql_error();. Co pole obsahuje, se nejlepe zjistuje pomoci funkce print_r. Do tela cyklu vloz print_r($zaznam);. |
||
| Kajman_ Profil * |
#5 · Zasláno: 19. 9. 2008, 00:35:36
$result = mysql_query ('SELECT tymy.nazev AS tymA, (SELECT nazev FROM tymy WHERE tymy.id = zapasy.id_tymB) AS tymB, tip.tip AS tip FROM tip'
. ' INNER JOIN zapasy ON tip.id_zapas = zapasy.id'
. ' INNER JOIN tymy ON zapasy.id_tymA = tymy.id'
. ' WHERE tip.id_uzivatel =1 '
. ' ORDER BY tip.id_tip DESC') or die(mysql_error());
|
||
| pito Profil |
#6 · Zasláno: 19. 9. 2008, 00:43:34
pise mi to chybu Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /3w/wz.cz/i/icq5pool/tipes.php on line 16
a 16 radek je tohle: echo ."$zaznam['tymA']."; |
||
| BetaCam Profil |
#7 · Zasláno: 19. 9. 2008, 03:51:02
pito
require "db.php";
$result = mysql_query ('SELECT tymy.nazev AS tymA,
(SELECT nazev FROM tymy WHERE tymy.id = zapasy.id_tymB) AS tymB,
tip.tip AS tip
FROM tip
INNER JOIN zapasy ON tip.id_zapas = zapasy.id
INNER JOIN tymy ON zapasy.id_tymA = tymy.id
WHERE tip.id_uzivatel =1
ORDER BY tip.id_tip DESC');
while($zaznam = mysql_fetch_array($result)) {
echo $zaznam['tymA'];
echo $zaznam['tymB'];
echo $zaznam['tip'];
}
|
||
| pito Profil |
#8 · Zasláno: 19. 9. 2008, 09:17:43
moc ti dekuji BetaCam
|
||
|
Časová prodleva: 16 let
|
|||
0