d more than one Session on the same day, it'll return
more than one line for that person with different AttID's.
Just some random thoughts.
-TG
> -Original Message-----
> From: John Holmes [mailto:[EMAIL PROTECTED]
> Sent: Saturday, November 20, 2004 10:22 AM
> To: GH
&
Usse PHP to control the output, test for the value and if it changes show
else don't show it
bastien
From: GH <[EMAIL PROTECTED]>
Reply-To: GH <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: [PHP-DB] Optimize Query Output
Date: Sat, 20 Nov 2004 00:39:36 -0500
I have the foll
GH wrote:
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 t
the display really has nothing to do with SQL but rather your php
output format. you would use php to display the data however you want
it formatted.
--
Joseph Crawford Jr.
Codebowl Solutions
[EMAIL PROTECTED]
For a GMail account
contact me OFF-LIST
--
PHP Database Mailing List (http://www.p