Group?

[lukeurtnowski]

Here is my sql statment which produces several records
select , DATE_FORMAT(a_date, '%m/%d/%Y') as a_date_formatted from company, activity where c_id=a_c_id and medivas ='$poc'
im trying to group these records depending on the medivas field (which is either A, B, or C) so tha all the As', Bs' and Cs' would be grouped together (like this)
select , DATE_FORMAT(a_date, '%m/%d/%Y') as a_date_formatted from company, activity where c_id=a_c_id and medivas ='$poc' GROUP by medivas
but this only returns 1 record?

[lucasrd]

Do you just mean you want to order your records?

select *, DATE_FORMAT(a_date, '%m/%d/%Y') as a_date_formatted from company, activity where c_id=a_c_id and medivas ='$poc' ORDER BY medivas ASC