* DL Neil > Consider: > a) add a 'construction' table with the row-values 0 through 11 > (or 23) and use it to do a left join against the > messages tbl; > b) if the database is not busy, use perl to fire off 12 (or 24) > separate queries.
c) use perl to 'fill in the holes', putting zero values in the 'empty slots' of an array 0-23 -- Roger query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php