Matho píše:
este taky dotaz, ako zistim nazov tabulky z ktorej mi nacitalo vysledny - najdeny text. Pouziva sa na to mysql_field_table(), no ta mi ukaze nazov tabulky "tabulka"
sa s manualom MySql asi nekamaratis
Kód:
select * from
(
( SELECT
nazov AS xNazov,
text AS xText,
datum AS xDatum,
'tab1' as tablename
FROM tab1
)
union
( SELECT
nazov AS xNazov,
text AS xText,
datum AS xDatum,
'tab2' as tablename
FROM tab2
)
union
( SELECT
nazov AS xNazov,
text AS xText,
datum AS xDatum,
'tab3' as tablename
FROM tab3
)
) as tabulka
where tabulka.xNazov ...
order by tabulka.xDatum ...