";
}
function news()
{
echo "Новости
";
db_connect() or die("Cannot connect to server");
$query="SELECT id, n_date, n_title FROM news ORDER BY n_date DESC LIMIT 5";
$result = mysql_query($query) or die ("Невозможно выполнить запрос");
$i=0;
while ($row = mysql_fetch_row($result))
{
$i++;
$new_date = explode("-",$row[1]);
$OK_date = $new_date[2]."-".$new_date[1]."-".$new_date[0];
echo "$OK_date $row[2] подробнее
";
}
mysql_free_result ($result);
echo "
|
";
}
function reccomend()
{
$query = "SELECT recomend.brat, recomend.bcode, books.bname, books.bauthor FROM recomend, books WHERE recomend.bcode=books.bcode ORDER BY recomend.brat LIMIT 10;";
$result = mysql_query($query) or die ("Невозможно выполнить запрос");
echo "
Рекомендуемая литература
";
while ($row = mysql_fetch_row($result))
{
echo "$row[3] $row[2]";
}
echo "
|
";
}
function shopnet()
{
db_connect() or die("Cannot connect to server");
echo "";
echo "
";
echo "Сеть магазинов
";
$query_city = "SELECT id, value FROM city ORDER BY id;";
$result_city = mysql_query($query_city) or die ("Невозможно выполнить запрос");
while ($row_city = mysql_fetch_row($result_city))
{
echo "$row_city[1]
";
$query="SELECT title,address,phone,id FROM shops WHERE city='$row_city[0]';";
$result = mysql_query($query) or die ("Невозможно выполнить запрос");
while ($row = mysql_fetch_row($result))
{echo "$row[0]";
if (file_exists("images/shops/$row[3].jpg"))
{echo " (схема проезда)";};
echo "
$row[1]; тел. $row[2]
";}
echo " | ";
}
echo "
|
";
}
function right_menu()
{
$query = "SELECT newbooks.brat, newbooks.bcode, books.bname, books.bauthor FROM newbooks, books WHERE newbooks.bcode=books.bcode ORDER BY newbooks.brat LIMIT 5;";
$result = mysql_query($query) or die ("Невозможно выполнить запрос");
echo "
";
$query = "SELECT liderbooks.brat, liderbooks.bcode, books.bname, books.bauthor FROM liderbooks, books WHERE liderbooks.bcode=books.bcode ORDER BY liderbooks.brat LIMIT 5;";
$result = mysql_query($query) or die ("Невозможно выполнить запрос");
echo "
";
$query = "SELECT skorobooks.bcode, skorobooks.bname, skorobooks.bauthor, skorobooks.bpublish, skorobooks.bdate FROM skorobooks ORDER BY skorobooks.bdate LIMIT 5";
$result = mysql_query($query) or die ("Невозможно выполнить запрос");
$num_rows= mysql_num_rows($result);
if ($num_rows<>0)
{
echo "
";
};
echo "
| ";
# echo "
# 
|
# |
#
# |
#
";
}
?>
