Word Activity Application

From: 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

« previous php.db (#47593) next »