php - GROUP BY mysql showing only one row. But want repetitions also -
my table structure id order_id location time date 1 951 x 2/03/2013 2 951 x 13:00 2/03/2013 3 951 y 3/03/2013 i want show these in php group date like date 2/03/2013 orderid 951 location x orderid 951 location x date 3/03/2013 orderid 951 location y mysql query im performing select * table order_id=951 group date order id asc but query return first row of same data . how can show repetition in group date category. how use in php show data taking date separate variable. i editing question let know date can want order id show date in group including repetition. if want show rows in table, better order date, id grouping in php. $result = mysql_query("select * table order data asc,id asc"); $last_date = ""; while(($row=mysql_fetch_assoc($result))) { if($last_date != $row['date']) { echo "date " . $row['date'] . "\n"; ...