1. When using "GROUP BY" it is not possible to order the rows before the grouping
takes place, is that right? Like, if you're selecting books, grouping on author, and
you want to show the first book of each author, you'd want to order by date and then
group by author?
2. Other grouping question, let's say I have those books again, and I want to display
all the books, ordered by author, and know how many books by each author there are as
well, like so:
Name: Bks: Title:
Author A | 3 | booktitle_1
Author A | 3 | booktitle_2
Author A | 3 | booktitle_3
Author B | 1 | booktitle_4
Author C | 2 | booktitle_5
Author C | 2 | booktitle_6
Is this possible in one query? Using two at the moment, first a count(*), group by
books and then fetching them all, using the count value for ROWSPAN value in HTML.
TIA!
Regards,
Martin
--
<mailto:mac.com@;nemo>
<http://www.mechintosh.com/>
---------------------------------------------------------------------
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
