Hello, and thanks for the reply.
I dont' know PHP, but I can understand that you are suggesting to "manually"
iterate the records to find the events, and group them by day. Is this right?
"C.Peachment" <[EMAIL PROTECTED]> ha scritto: What is wrong with using:
select EventID, EventDate, EventTime
order by EventDate, EventTime
group by EventDate;
You have a separate display problem - you want
to put up to three records on the same line. This is
a language and application specific problem. In PHP,
using the PDO module and producing output for a
web page, it can be solved with something like:
$SqlText = "select EventID, EventDate, EventTime " .
" order by EventDate, EventTime " .
" group by EventDate";
$Stmt = $dbh->prepare($SqlText);
$Stmt->execute();
$Found = false;
$PriorDate = 0;
while ($Row = $Stmt->fetch(PDO::FETCH_OBJ)) {
$Found = true;
if ($Row->EventDate != $PriorDate) {
if ($PriorDate != 0) {
echo "
\n";
}
echo "$Row->EventID, $Row->EventDate";
}
echo "$Row->EventTime";
$PriorDate = $Row->EventDate;
if ($Found) {
echo "
\n"; // close off last output statement
$Stmt->closeCursor();
On Mon, 10 Jul 2006 11:45:24 +0200 (CEST), [EMAIL PROTECTED] wrote:
>Hello, everybody
>I have the following problem: I have a table that contains "Events", with the
>related date and time:
>Fields:
>EventID
>EventDate
>EventTime
>I would like to "group" these records by day, returning all the "times" of the
>events, like:
>EventID, EventDate, EventTime1, EventTime2, EventTime3
>(I can assume that no more than 3 events happen on the same day).
>I did this query:
>SELECT T1.EventDate, T1.EventTime AS Time1, T2.EventTime AS Time2
>FROM Events AS T1 LEFT JOIN Events AS T2 ON T2.EventDate = T1.EventDate AND
>T2.EventTime > T1.EventTime;
>This query "works", but it has the following problems:
>1. it returns several times the same "record" (can't understand why)
>2. it takes about 30 seconds (!!) to run, and it consumes all the physical
>memory of the system...
>Any help on this?
>Thanks in advance for any reply.
>Kind regards
>Marco
> Chiacchiera con i tuoi amici in tempo reale!
> http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com
Chiacchiera con i tuoi amici in tempo reale!
http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com
