HI,
Die Abfrage scheint meine mysql Version nicht zu unterstützen
Woran liegt es ?
SQL-Befehl:
SELECT *
FROM ok_tabelle AS t1
INNER JOIN (
SELECT ROUND( RAND( ) * (
SELECT MAX( ID )
FROM ok_tabelle ) ) AS ID
) AS t2 ON t1.ID >= t2.ID
ORDER BY t1.ID ASC
LIMIT 1
MySQL meldet:
#1064 - 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 'SELECT
ROUND(RAND() * (SELECT MAX(ID) FROM ok_tabelle)) AS
Grüße Silli