Nov
30
awarded Benefactor
Nov
28
comment Retrieving most recent records in groups
Thank you!!! Works perfectly!
Nov
28
awarded Promoter
Nov
27
revised Retrieving most recent records in groups
added 387 characters in body
Nov
27
comment Retrieving most recent records in groups
Thank you very much. This mostly works.. It was throwing a column not known error ("status" column) so I tried changing the select line to "select status, max(id) as id"... But it seems to return one record for each group, whether the last one is active or not... (ie. if I add a fifth row with "5 Company1 Inactive" it still returns the row)
Nov
26
asked Retrieving most recent records in groups
Oct
25
comment Removing groups of similar records in MySQL query
That would work too! Thanks!
Oct
25
awarded Nice Answer
Oct
25
comment Removing groups of similar records in MySQL query
Ooooh! I get it. Thanks again!
Oct
25
comment Removing groups of similar records in MySQL query
I'm still trying to wrap my head around the HAVING sum part... What does that line do in this case? (I'm still a mySSQL relative beginner) - the reason I ask is I'm trying to work "- INTERVAL 1 DAY" to adjust the calculation of CURRDATE and having a tough time
Oct
25
accepted Removing groups of similar records in MySQL query
Oct
25
comment Removing groups of similar records in MySQL query
Ah, there we go! Elegant and awesome! Thanks so much!!!!
Oct
25
asked Removing groups of similar records in MySQL query
May
1
awarded Popular Question
Dec
20
comment Repopulating checkboxes in Codeigniter after Unsuccessful Form Validation
Thank you! I had the same problem and it was driving me crazy.
Sep
27
awarded Scholar
Sep
27
accepted Using JSON markers in Google Maps API with Javascript
Jun
6
awarded Supporter
May
12
awarded Editor
May
12
revised Using JSON markers in Google Maps API with Javascript
added 3 characters in body
1 2