ok, i search in the forum and there are some answears for this topic, but i cant make it work
i have linux running mysql 3.23.54
i want to search for a random record thats why i use:
Code: Select all
SELECT field1, field2 FROM table ORDER by RAND() Limit 1
i try using this too:
Code: Select all
SELECT field1, field2, RAND(NOW()) as rand_col FROM table ORDER BY rand_col LIMIT 1
Neither work on my linux server, but they do ok over windows!!!!, i supose i have to initialize the RAND??? but the RAND() is in the SQL statement not in the php code?... any clue?
thanks