Retrieve correct data from table

[RicardoMatos]

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???

 

[r937]

first, you have a mysql question but you posted in the ANSI SQL forum

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