List:General Discussion« Previous MessageNext Message »
From:Sue Cram Date:February 14 2005 7:47am
Subject:Re: Total Counts, Multi-Report Questions
View as plain text  
Thanks for the ideas, Dan.  I'm making progress!

----- Original Message ----- 
From: "Dan Nelson" <dnelson@stripped>
To: "Sue Cram" <shcram@stripped>
Cc: <mysql@stripped>
Sent: Sunday, February 13, 2005 12:34 AM
Subject: Re: Total Counts, Multi-Report Questions


> 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
>

Thread
Total Counts, Multi-Report QuestionsSue Cram13 Feb
  • Re: Total Counts, Multi-Report QuestionsDan Nelson13 Feb
  • Re: Total Counts, Multi-Report QuestionsSue Cram14 Feb