I am trying to write a mySQL query to determine if the current word being displayed in the game is one of the top 10 most popular. I am trying to achieve this by creating a table that tracks how many times each word was accessed. A new row is created for each access to the word. The table structure is as follows:
CREATE TABLE IF NOT EXISTS `bible_word_scramble_usage` ( `reference` int(25) NOT NULL AUTO_INCREMENT, `bible_dictionary_reference` int(4) NOT NULL, `ip_address` varchar(20) NOT NULL, `date_accessed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`reference`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=122 ; The following is the SELECT query I need help tweaking. What I am trying to do is select the top 10 most popular words and then use a second select to see if the word being displayed is one of the top 10 (IE using the search results of the 10 top SELECT query). The error this query is currently giving me is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= `top_ten`.`bible_dictionary_reference` = 1 LIMIT 1' This is the query: SELECT `top_ten`.`bible_dictionary_reference` FROM ( SELECT `bible_dictionary_reference` , COUNT( `reference` ) AS word_usage FROM `bible_word_scramble_usage` GROUP BY `bible_dictionary_reference` ORDER BY word_usage DESC LIMIT 10 ) AS top_ten WHERE = `top_ten`.`bible_dictionary_reference` =1 LIMIT 1 Thank you for helping me. Ron The Verse of the Day “Encouragement from God’s Word” http://www.TheVerseOfTheDay.info
