All pastes #128966 Raw Edit

Axs

public text v1 · immutable
#128966 ·published 2006-08-13 08:36 UTC
rendered paste body
<?php

$year, $month = 0;
$q_year = mysql_query('SELECT * FROM news ORDER BY date DESC');

while ($news_year = mysql_fetch_array($q_year)) {
	if (isset($year) && $year < date('Y', $news_year['date'])) {
                $q_month = mysql_query('SELECT * FROM news WHERE date > \''. $date .'\' AND date < \''. mktime(0, 0, 0, 12, 0, $year) .'\' ORDER BY date DESC');
                $year = date('Y', $news_year['date']);

                while ($news_month = mysql_fetch_array($q_month)) {
                        if (isset($month) && $month < date('n', $news_month['date'])) {
                                print('<h1>'. date('F', $news_month['date']) .' of '. $year .'</h1>' . "\n");

                        } else {
                                continue;

                        }
                }
	} else {
		continue;

	}
}

?>