Word Activity Application

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux