I have a 'Highlights' heading on my home page.  It is for links to content
on the site ... like specific web pages

I have designed the query below to select the two most popular and least
popular pages used on the site to be the Highlights.  (Each time a web
page is accessed user_hits is increased by 1.)

I would like to display a fifth one that is " ORDER BY RAND () LIMIT 1 "
--- Only I don't know how to ensure it isn't one of the four that are
being displayed already.  Any suggestions?


SELECT `highlights`.`reference`, `highlights`.`page_command`,
`highlights`.`page_title` FROM (

( SELECT `reference`, `page_command`, `page_title` FROM `user_pages` WHERE
 `include_in_highlights` =1 ORDER BY `user_hits` DESC LIMIT 2 )


( SELECT `reference`, `page_command`, `page_title` FROM `user_pages` WHERE
 `include_in_highlights` =1 ORDER BY `user_hits` ASC LIMIT 2 )

) AS highlights ORDER BY `highlights`.`page_title` ASC

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to