Word Activity Application
| From: | Ron Piggott | Date: | Sun, 02 Jan 2011 22:54:49 +0000 |
| Subject: | Word Activity Application | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47593@lists.php.net to get a copy of this message | ||
I am working on a word activity --- matching words and their definitions.
I want to display 5 words on the left hand side and the 5 definitions on the right hand side. But I
want the definitions displayed in a different order than the words so the user submits their answer.
Should I use PHP to display the definitions in random order? OR Is there a way do this in mySQL
that would mix and match results from different rows? This is the query gives me the 5 results
SELECT
reference , word , explanation
FROM Bible_dictionary
WHERE live =1
ORDER BY RAND( )
LIMIT 5
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info