Forum PHP.pl

[SQL] pobierz, plaintext 
SELECT 
    *
FROM
    (SELECT 
        *, data_roz AS d
    FROM
        strony
    WHERE
        idk = 7
            AND data_roz >= CURRENT_DATE + INTERVAL 1 DAY
            AND (STATUS = 2 OR STATUS = 1) UNION SELECT 
        *, data_do AS d
    FROM
        strony
    WHERE
        idk = 4 AND data_do >= CURDATE()
            AND (STATUS = 2 OR STATUS = 1)) a
ORDER BY a.d ASC;
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
ORDER BY CASE WHEN idk=4 THEN data_do WHEN idk=7 THEN data_roz END
[SQL] pobierz, plaintext