SELECT *
FROM mytable
ORDER BY RAND() LIMIT 0,20
thats my Query and pretty much it gets 20 words out of a list of 150 and displays them randomly…but what i’m having trouble is how to seperate these words as 1 per recordset if that makes sense so i can display all 20 in a table 1 word in each cell…and i hoping do this some how through mysql or do i need to do this through php…i am using the recordset thingy through dreamwever…NOT HAND CODING IT…(can’t be bothered lol)
Cheers in advance
PS ATM i have one word repeating 20 times which is a different word each time the page refreshes