title: Grouping of date fetch from database
body: <p>I am using this query to select rows from the database</p>
  
  <pre><code>$date=mysql_query("SELECT party_id, advo_id, max(fixed_date) as d FROM `case_proceeding` group by party_id order by fixed_date");
  </code></pre>
  
  <p>
  
  <pre><code>    while($drow=mysql_fetch_array($date)){  
  
      if($drow['d']&lt;$today){
  
          $decide=mysql_query("select * from case_decision where party_id='$drow[party_id]'");
  
          if(mysql_num_rows($decide)=='0')
          {
  
              if($drow['d']!='0000-00-00')
              {
                  echo '&lt;a href=case-tracking.php?date='.$drow['d'].'&amp;party_id='.$drow['party_id'].'&amp;advo_id='.$drow['advo_id'].' style=color:#000000;&gt;'.date('d/m/Y',strtotime($drow['d'])).'&lt;/a&gt;';
              }
  
          }
  </code></pre>
  
  <p>there are many rows that has same fixed_date.</p>
  
  <p>eg. party_id=1 has fixed_date=2012-08-12
  and party_id=5 has also the same date fixed_date=2012-08-12</p>
  
  <p>now I want to make groups of the rows that have same fixed_date.</p>
  
  <p>Please help me.</p>