Message-
From: John Holmes [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 20, 2004 10:22 AM
To: GH
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Optimize Query Output
GH wrote:
I have the following query:
SELECT A.`AttID` , S.`SessionDate` , P.LastName
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
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
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
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