subject:"\[PHP\-DB\] SELECT \/ ORDER BY"

Re: [PHP-DB] SELECT / ORDER BY

2010-09-13 Thread Richard Quadling

On 11 September 2010 07:47, Ron Piggott ron.pigg...@actsministries.org wrote: I wrote the query below to determine the 10 most popular words used: SELECT COUNT( `bible_concordance_usage`.`reference` ) AS word_usage, `bible_concordance_words`.`reference` , `bible_concordance_words`.`word`

[PHP-DB] SELECT / ORDER BY

2010-09-11 Thread Ron Piggott

I wrote the query below to determine the 10 most popular words used: SELECT COUNT( `bible_concordance_usage`.`reference` ) AS word_usage, `bible_concordance_words`.`reference` , `bible_concordance_words`.`word` FROM `bible_concordance_usage` INNER JOIN `bible_concordance_words` ON

Re: [PHP-DB] SELECT / ORDER BY

2010-09-11 Thread Karl DeSaulniers

Hello, This may help. http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html Best, Karl On Sep 11, 2010, at 1:47 AM, Ron Piggott wrote: I wrote the query below to determine the 10 most popular words used: SELECT COUNT( `bible_concordance_usage`.`reference` ) AS word_usage,