if it a mysql timestamp then you could use this function to display the date
CODE
function time_format($timestamp)
{
$hour = substr($timestamp,8,2);
$minute = substr($timestamp,10,2);
$second = substr($timestamp,12,2);
$month = substr($timestamp,4,2);
$day = substr($timestamp,6,2);
$year = substr($timestamp,0,4);
$mktime = mktime($hour, $minute, $second, $month, $day, $year);
$formated = date("F j, Y, g:i a",$mktime);
return $formated;
}
so you just use something like this to select it all
CODE
//querystring
$month = 12; // DECEMEBER
$year = 2000;
//old rant
if ($month==01) {
$month = 00;
} else if ($month<10) {
$month = "0$month";
}
$date_prev = "$year".($month - 1)."00000000";
$date_next = "$year".($month + 1)."00000000";
$result = mysql_query("SELECT * FROM blog WHERE date<'".$date_next."' AND date>'".$date_prev."' ORDER BY date DESC");
while ($blogresult = mysql_fetch_array($result)) {
//echo all stuff in here
}
3 Nov, 2002 - 09:18 PM
| 