RE: [PHP-DB] Optimize Query Output

Usse PHP to control the output, test for the value and if it changes show
else don't show it

bastien

>From: GH <garyhotko@gmail.com>
>Reply-To: GH <garyhotko@gmail.com>
>To: php-db@lists.php.net, mysql@lists.mysql.com
>Subject: [PHP-DB] Optimize Query Output
>Date: Sat, 20 Nov 2004 00:39:36 -0500
>
>I have the following query:
>
>SELECT A.`AttID` , S.`SessionDate` , P.LastName, P.FirstName, A.`Present`
>FROM `Attendance` A, Sessions S, Participants P
>WHERE S.SessionID = A.`Session` AND P.Part_ID = A.`Participant`
>GROUP BY P.LastName, P.FirstName, A.Present, A.AttID
>
>I would like to have the output to have the P.LastName and P.FirstName
>values only shown once and the rest of the output printed...
>
>So instead of something like:
>
>+-------+-------------+-------------+-----------+---------+
>| AttID | SessionDate | LastName    | FirstName | Present |
>+-------+-------------+-------------+-----------+---------+
>|     1 | 2004-10-30  | Apple     | Robert  | Yes     |
>|    11 | 2004-11-06  | Apple     | Robert  | Yes     |
>|    31 | 2004-11-13  | Apple     | Robert  | Yes     |
>|     2 | 2004-10-30  | Bravo     | Lisa       | Yes     |
>|    32 | 2004-11-13  | Bravo     | Lisa       | Yes     |
>|    12 | 2004-11-06  | Bravo     | Lisa       | No      |
>|     3 | 2004-10-30  | Beta   | Elaine    | Yes     |
>|    13 | 2004-11-06  | Beta   | Elaine    | Yes     |
>|    14 | 2004-11-06  | Delta | Alexander | Yes     |
>|    35 | 2004-11-13  | Delta | Alexander | Yes     |
>....
>
>
>To have it look like:
>
>+-------------+-----------+-------+-------------+---------+
>| LastName    | FirstName | AttID | SessionDate | Present |
>+-------------+-----------+-------+-------------+---------+
>| Apple     | Robert S. |     1 | 2004-10-30  | Yes     |
>|               |               |    11|  2004-11-06 | Yes     |
>|               |               |    31|  2004-11-13 | Yes     |
>| Bravo     | Luz       |     2 | 2004-10-30  | Yes     |
>|              |             |    32|  2004-11-06 | No     |
>|               |               |    12|  2004-11-13 | Yes     |
>| Beta   | Elaine    |     3 | 2004-10-30  | Yes     |
>|          |               |    13|  2004-11-06 | Yes     |
>| Delta  | Alexander |    14 | 2004-11-06  | Yes     |
>|               |               |    35|  2004-11-13 | Yes     |
>.....
>
>Please advise I am running on mySql 4.0
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>