# Mysql query help?

**URL:** <https://forum.kirupa.com/t/mysql-query-help/226525>\
**Category:** Uncategorized\
**Created:** [May 22, 2007, 3:55am UTC](https://forum.kirupa.com/t/mysql-query-help/226525 "2007-05-22T03:55:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Flash\_Man1](https://avatars.discourse-cdn.com/v4/letter/f/8797f3/32.png) [@Flash\_Man1](https://forum.kirupa.com/u/Flash_Man1)\
**Post date:** [May 22, 2007, 3:55am UTC](https://forum.kirupa.com/t/mysql-query-help/226525/1 "2007-05-22T03:55:52Z")

</div>

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