Hi im trying to random showing items from data base and when echoed the same ones appear? If anyone could help that would be great. This is the query
SELECT * FROM TABLE1, TABLE2 WHERE FIND_IN_SET(TABLE2.FIELD1, TABLE1.FIELD1) and `FIELDNAME` >= RAND() LIMIT 10