| |
| |
|
| |
0){
while ($row = mysql_fetch_array($result, MYSQL_BOTH)){
if ($id != ""){
$query_type = "id";
$query2 = "SELECT * FROM Blog WHERE ID = '$id' AND Visible = 'yes' ORDER BY PostDate ASC";
} else {
if ($month!= ""){
$query_type = "month";
$query2 = "SELECT * FROM Blog WHERE DATE_FORMAT(PostDate, '%Y') = '$year' AND DATE_FORMAT(PostDate, '%M') = '$month' AND DATE_FORMAT(PostDate, '%M %d %Y') = '".$row[0]."' ORDER BY PostDate ASC";
} else {
$query2 = "SELECT * FROM Blog WHERE DATE_FORMAT(PostDate, '%M %d %Y') = '".$row[0]."' ORDER BY PostDate ASC";
}
}
$result2 = mysql_query($query2);
while ($row2 = mysql_fetch_array($result2, MYSQL_BOTH)){
if ($query_type == "recent" && $row2['Visible'] == 'yes'){
$post_no++;
}
if ($row2['Visible'] == 'yes' && $post_no <= $Recent){
?>
$date
";
echo "$line";
} else{
if ($row3[0] != $date){
$date = $row3[0];
echo "$date
";
echo "$line ";
}
}
//DISPLAY HEADER
if ($Header != ""){
echo "".$row2['Header']."
";
}
//DISPLAY CONTENT
$Content = stripslashes(trim($row2['Content']));
$Content = ereg_replace("'", "'", $Content);
$Content = ereg_replace("apos;", "'", $Content);
if ($Content != ""){
echo "".$Content." ";
}
?>
|
=300){
?>
![<? echo $row4['Picture']?>](<?php echo $img_path; ?> "<? echo $row4['Picture']?>")
|
|
|
|
" valign="top" align="right">
Go To Main Page
|
| |
|
" valign="top" align="right">
|
|
|
|