From: Dan Nelson
Date: February 13 2005 8:34am
Subject: Re: Total Counts, Multi-Report Questions
List-Archive: http://lists.mysql.com/mysql/179855
Message-Id: <20050213083454.GA43303@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Feb 12), Sue Cram said:
> I have a request for a list of database entries "Select x,y,z, etc"
> that is now working OK.  I have several questions, however.  Here
> they are:
>
>   1.. Can I add a "total" line at the bottom of the report (ex:
>   "Total Selected: 23") for the total number of entries that are
>   listed in the report?

It's your report, you can put whatever you want in :)  Simply print the
size of the resultset of your main query, or if whatever
language/reporting tool you're using can't do that, just do a SELECT
COUNT(*) with the same WHERE clause.

>   2.. I want to print the same information but sorted in a different
>   order on a second page of the report.  Can I do that in one
>   "Select" statement?

If your language supports it, you can re-sort your resultset with a
custom comparison fuction and display it again.  Otherwise, you'll need
another SELECT.

>   3.. If I need multiple select statements, is there a delimiter that
>   says "This is the end of my first select statement - the next thing
>   you see is going to be a new select statement", so that all the
>   necessary pages can be printed together in one "job"?

So you want the same records to be returned in two orders, but as one
resultset?  Stick two queries together with a UNION ALL keyword.

http://dev.mysql.com/doc/mysql/en/union.html

-- 
	Dan Nelson
	dnelson@stripped