Seperating Groups - almost there

localhero · #1 (**permalink**) 04-24-09, 14:21

Lets say I have a table with 1 column having a list of months:
Jan, Jan, Feb, Jan, Feb, Feb, Jan, Feb
And another column having a list of dates associated with those months:
1,2,5,7,14,12,30,16
It looks like this:
Jan | 1
Jan | 2
Feb | 5
Jan | 7
Feb | 14
Feb | 12
Jan | 30
Feb | 16

I want to view the results like this:
Jan
1
2
7
30

Feb
5
14
12
16

Here is what I'm working with:

PHP Code:


			
<?php

$sql="SELECT month, day FROM calendar GROUP BY month";

$sql2="SELECT month, day FROM calendar ORDER BY month";

$result=mysql_query($sql);

$result2=mysql_query($sql2);

while($rows=mysql_fetch_array($result)){

?>

<table><tr><td>

<?php echo( $rows['month'] ); ?>

</td></tr><tr><td>

<?php

while($rows2=mysql_fetch_array($result2)){

echo $rows2['day'] ;?>



 }

?>

</td></tr></table>

<?php

 }

?>

I'm getting 2 tables - Jan & Feb, but all the dates go in Jan. I can see why it's doing that. I can't figure out how to get the Feb dates over in the Feb table. Thanks for any suggestions or direction.

mike_bike_kite · #2 (**permalink**) 04-25-09, 09:34

I didn't try it but the following might be close:

Code:

<?php
   print( "<table>" );
   $current_month="";

   $sql="SELECT month, day FROM calendar ORDER BY month,day";
   $result=mysql_query($sql);

   while( list( $month,$day ) = mysql_fetch_row($result) ) {
        if ( $month != $current_month ) {
              print( "<tr><td>$month</td></tr>" );
              $current_month=$month;
        }
        print( "<tr><td>$day</td></tr>" );
   }

   print( "</table>" );
?>

r937 · #3 (**permalink**) 04-25-09, 09:48

Code:

SELECT month
     , day 
  FROM calendar
ORDER
    BY FIND_IN_SET(month
          ,'Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec')
     , day

Internet Services

Web Development

Digital Marketing

Consumer Tech