Group By Multiple results

[datoshway]

My group by statement is only returning one result if they are the same data. Need this to display all results even if they are the same.  See below what I have.  Thanks in advance.

$sql = "SELECT * FROM calendar_event GROUP BY month, day, year ORDER BY month, day, year ASC"; 
$result = mysql_query($sql);

$count = mysql_num_rows($result);

[The Little Guy]

"GROUP BY" automatically order the results, so you shouldn't need the "ORDER BY".

 

If I understand your question, maybe this will work:

$sql = "SELECT * FROM calendar_event GROUP BY CONCAT(month, day, year)";

[datoshway]

That worked!  Thanks!

[fenway]

Yeah, but you can't use *.