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