Retrieve correct data from table
Retrieve correct data from table
(OP)
Hi there! I'm having a little problem with a mysql table.
Here's the thing: I have a table to store announcements. When retrieving data from the table, if more than one record is found on a same day, repet only the announcent and not the time and date posted, like this:
July 24 2009
-> Some text......
-> Some text 2.....
July 23 2009
-> Some other text
Not like this
July 24 2009
-> Some text......
July 24 2009
-> Some text.....
Any help???
Here's the thing: I have a table to store announcements. When retrieving data from the table, if more than one record is found on a same day, repet only the announcent and not the time and date posted, like this:
July 24 2009
-> Some text......
-> Some text 2.....
July 23 2009
-> Some other text
Not like this
July 24 2009
-> Some text......
July 24 2009
-> Some text.....
Any help???
RE: Retrieve correct data from table
second, the cosmetic manipulation of query results should be done in your front-end application language, not sql
the query should simply return the results like this --
July 24 2009 Some text......
July 24 2009 Some text 2.....
July 23 2009 Some other text
note that query results are actually a table
your front-end app then re-arranges this whichever way you need to see it
r937.com | rudy.ca
Buy my new book Simply SQL from Amazon