The SQL query will do the grouping and present them in the correct sequence.
All programming languages require that you iterate over the set of retrieved
records. What you do with them as you retrieve them is up to you.
Code would look quite similar in 'C' and would have the same structure in any
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, Event
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 prod
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, E
4 matches
Mail list logo
