Hi
I have a (probably fairly simple newbie question:
Using a select statement (via DBI) I get some details from a table and
at the same time have a row count of how many rows are returned (to be
displayed at the website).
A query like
select count(nation) AS nation, name, nation from memberscopy
where nation = "Austrian" order by course;
results in the following error:
ERROR: Query failed (Mixing of GROUP columns
(MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there
is no GROUP BY clause)
If I use :
select count(*) AS nation, name, nation from memberscopy where
nation = "German" group by surname order by course ;
I get those details
| nation | name | nation |
| 1 | Christian | Austrian |
| 1 | Christian | Austrian |
| 1 | Maximilian | Austrian |
| 1 | Edgar Alexander | Austrian |
| 1 | Erik | Austrian |
| 1 | Maria | Austrian |
Is there any way that I can get a line count of the result set and the
details with onl one query?
Thanks for your help!
Sven
---------------------------------------------------------------------
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
