Douprava SQL: SOS KAJMAN

tvuj poupraveny select

SELECT HRAC, UNIX_TIMESTAMP( d ) AS d
FROM (

SELECT d_hrac AS HRAC, min( datum ) AS d
FROM vysledky_ladder
GROUP BY d_hrac
UNION ALL SELECT h_hrac AS HRAC, min( datum ) AS d
FROM vysledky_ladder
GROUP BY h_hrac
) AS TMP
GROUP BY HRAC


produkuje

Cislo hrace : unixovy cas


Vse v poradku jenze potrebuji jeste

1/ rozlisit podminkou id_souteze ( where id_souteze=cislo)
2/ vytahnout Idcko zapasu

Ani 1 ani 2 mi za boha nefunguje.

Pak uz to bude kompletni!

DIKY!!!!

select HRAC, d FROM (


SELECT d_hrac AS HRAC, max( datum) as d

FROM vysledky_ladder
WHERE id_souteze=10
GROUP BY d_hrac

UNION ALL

SELECT h_hrac AS HRAC, max( datum) as d

FROM vysledky_ladder
WHERE id_souteze=10
GROUP BY h_hrac
) as TMP GROUP BY HRAC


takze tady je to za 1/

a za 2/ nevim. Kajmušo .. :-*