archiving by year, and then month, using timestamp

[exolution]

So the goal here is to go to archive.php, and see a list of years in bold, and then under those years there be all the months that news existed. I've been trying for a few days to do this effectively and I can't seem to pull it off.

I have a timestamp field in "news" named "date", and I use now() to fill it, so 20030217210336 would be the same as february 17th, 2003 @ 9:03pm. Get back to me guys, thanks.

[cgraz]

probably not the cleanest way to do this, but since nobody else responded, you could try this:

<?

include("config.php");

// Connect To MySQL Server
@mysql_connect($server, $username, $password) or die("Couldn't Connect to Database");

// Select Database
@mysql_select_db($database) or die("Couldn't Select Database");

$query = mysql_query("SELECT DATE_FORMAT(inputedon, '%Y') AS year, DATE_FORMAT(inputedon, '%m') AS month FROM stock ORDER BY year, month") or die(mysql_error());

while($row = mysql_fetch_array($query)) {

  $row["month"] = str_replace("01", "January", $row["month"]);
  $row["month"] = str_replace("02", "February", $row["month"]);
  $row["month"] = str_replace("03", "March", $row["month"]);
  $row["month"] = str_replace("04", "April", $row["month"]);
  $row["month"] = str_replace("05", "May", $row["month"]);
  $row["month"] = str_replace("06", "June", $row["month"]);
  $row["month"] = str_replace("07", "July", $row["month"]);
  $row["month"] = str_replace("08", "August", $row["month"]);
  $row["month"] = str_replace("09", "September", $row["month"]);
  $row["month"] = str_replace("10", "October", $row["month"]);
  $row["month"] = str_replace("11", "November", $row["month"]);
  $row["month"] = str_replace("12", "December", $row["month"]);

   if ($row["year"] == '2003') {
      $month_array0[] = $row["month"];
   }

// previous year

   if ($row["year"] == '2002') {
      $month_array1[] = $row["month"];
   }


}

$month_array0 = array_unique($month_array0);
$month_array1 = array_unique($month_array1);

echo "<b>2003</b><br>";
foreach($month_array0 as $value) {
   echo $value . "<br>";
}

echo "<br><b>2002</b><br>";
foreach($month_array1 as $value) {
   echo $value . "<br>";
}


?>

Cgraz

[kucukadam]

i am not sure if you want to learn that, but i am answering..

echo date("Y d M","20030217210336");

[exolution]

I've been messing around and I came up with some code, but it doesn't display anything (although it looks like it should). Here's the code.

<?php include("db.php");

$query = mysql_query("SELECT date, DATE_FORMAT(date, '%Y') AS year FROM news order by date desc");
while($r = mysql_fetch_array($query)) {
      $row = array_unique($r);
	  $unique_year = $row['year'];
	  echo($unique_year); ?><br><?php

  $query2 = mysql_query("select date, date_format(date, '%M') as month from news where date like '$unique_year%' order by date desc");
  while($r2 = mysql_fetch_array($query2)) {
  		$row2 = array_unique($r2);
		$unique_month = $row2['month'];
  		echo($unique_month); ?><br><?php
  }

}
?>

And it's located at: http://www.theoryofexolution.com/archive.php you can see the news it's getting from the database at http://www.theoryofexolution.com