PROS! Some DATE help?

[brianb]

Hello Pros,

Wondering if it was possible to get a little help with some DATE code.

Basically, I have a database with enteries containing dates in the format: 2002-11-18

Now, what I'm looking to do is to LIST every MONTH of the year....then under each MONTH, each entry listed under that MONTH will be categorized under that MONTH. Then on to the next MONTH....all this happening on the same page.

Additionally, I'd like to do this same listing by WEEK on another page. The week get's printed out, then every entry with a date under that week get's grouped and listed under it's appropriate week (split up by whatever month it is)

Make sense?

Any code examples are greatly appreciated.

Thanks in advance.

[herve]

Hi,

$query="SELECT my_id, mydate, MONTH(mydate) AS month FROM mytable ORDER BY month";

$result = mysql_query($query) or die("Query failed");

$previous_month = "";

while ($myrow = mysql_fetch_array($result))
{
$id = $myrow["my_id"];
$month = $myrow ["month"];
$mydate = $myrow["mydate"];

   if ($month != $previous_month)
   {
           print "<HR>";
           print "Month : $month<BR>";
           $previous_month = $month;
   }

   print "my_id = $my_id<BR>";
   print "my_date = $my_date<BR>";
   // print the rest of the data here

}

This will work for a given year, but you also need to do
a sort on the year (alone) in the SQL statement, otherwise
the January of year 2002 will follow the January of year 2001
which may not be what you really want 😃

Left as an exercise for you ! (the idea is the same as for the
month)

Hervé.