SELECT DISTNICT investice_isps.*
FROM investice_isps, investice_isp_lokality, investice_lokality, investice_patere
WHERE investice_isp_lokality.lokalita=investice_patere.lokalita
AND investice_lokality.id=investice_isp_lokality.lokalita
AND investice_isps.id=investice_isp_lokality.isp_id
AND investice_patere.isp!=investice_isps.id
ale mysql_error(); vraci nasledujici chybu:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.* FROM investice_isps, investice_isp_lokality, investice_lokal' at line 1
kdyz jsem pokusoval se () u te tabulky, vynechat .*, tak to bud hodilo dalsi error nebo to nevratilo ani ň
Poradite ? Dik
// samozrejme sem to konzultoval s mysql manualem, ale tam nic detailniho o DISTNICTu v strance o SELECTu nebylo
a jeste jsem zapomnel: bezi to na apache 2.0.59, PHP 5.2.1, MySQL 5.0.x (nevim z hlavy), na Win32

