Новости
";
echo "
Извините, новостей пока нет
";
echo " |
| ";
}
else
{
news($id);
right_menu();
}
bottom();
#-functions--------------------------------------------------------------------
function news($id)
{
echo "
Новости
";
db_connect() or die("Cannot connect to server");
if ($id=="all")
{$query="SELECT n_date, n_title, n_content FROM news ORDER BY n_date DESC LIMIT 8;";}
elseif ($id=="month")
{
global $month, $year;
echo "";
echo "Архив новостей за $month/$year
";
$mindate=$year."-".$month."-01";
$maxdate=$year."-".$month."-31";
$query="SELECT n_date, n_title, n_content FROM news WHERE n_date>='$mindate' AND n_date<='$maxdate' ORDER BY n_date DESC";
}
else
{
echo "";
$query="SELECT n_date, n_title, n_content FROM news WHERE id='$id' LIMIT 1;";
}
$result = mysql_query($query) or die ("Невозможно выполнить запрос");
$i=0;
while ($row = mysql_fetch_row($result))
{
$i++;
$new_date = explode("-",$row[0]);
$OK_date = $new_date[2]."-".$new_date[1]."-".$new_date[0];
echo "$row[1]
$row[2]
$OK_date
";
}
mysql_free_result ($result);
echo " |
| ";
}
function right_menu()
{
echo "
|
";
$cur_date = getdate (time());
$monthes = array ("", "Январь", "Февраль", "Март", "Апрель", "Май", "Июнь", "Июль", "Август", "Сентябрь", "Октябрь", "Ноябрь", "Декабрь");
db_connect() or die("Cannot connect to server");
$query = "SELECT n_date FROM news ORDER BY n_date LIMIT 1";
$result = mysql_query($query) or die ("Невозможно выполнить запрос");
$row = mysql_fetch_row($result);
$min_date = explode("-",$row[0]);
for ($i=1; $i<=9; $i++)
{
$test="0".$i;
if ($min_date[1]==$test)
{
$min_date[1]=$i;
break;
}
}
for ($i=$cur_date['year']; $i>=$min_date[0]; $i--)
{
echo "$i
";
if ($i==$cur_date['year'] && $i!=$min_date[0])
{
$min=1;
$max=$cur_date['mon'];
}
elseif ($i==$cur_date['year'] && $i==$min_date[0])
{
$min=$min_date[1];
$max=$cur_date['mon'];
}
elseif ($i==$min_date[0])
{
$min=$min_date[1];
$max=12;
}
else
{
$min=1;
$max=12;
}
echo "";
for ($j=$min; $j<=$max; $j++)
{
echo " $monthes[$j]
";
}
echo "";
}
echo " |
|
|
|
";
}
?>