opentable("Newsy");
$result = dbquery("SELECT * FROM ".$db_prefix."news WHERE news_cat='1' ORDER BY news_id DESC LIMIT 5");
echo "Ostatnie newsy:
";
$rows = dbrows($result);
if ($rows != 0) {
while ($row = mysql_fetch_array($result))
{
echo "![](".THEME."images/bullet.gif)
[".showdate("newsdate", $row["news_datestamp"])."] ".$row['news_subject']."
";
}
} else {
echo "Brak danych do wyświetlenia w statystykach";
}
echo "
";
$result = dbquery("SELECT * FROM ".$db_prefix."news WHERE news_cat='2' ORDER BY news_id DESC LIMIT 5");
echo "Ostatnie newsy:
";
$rows = dbrows($result);
if ($rows != 0) {
while ($row = mysql_fetch_array($result))
{
echo " [".showdate("newsdate", $row["news_datestamp"])."] ".$row['news_subject']."
";
}
} else {
echo "Brak danych do wyświetlenia w statystykach";
}
echo "
";
$result = dbquery("SELECT * FROM ".$db_prefix."news WHERE news_cat='3' ORDER BY news_id DESC LIMIT 5");
echo "Ostatnie newsy:
";
$rows = dbrows($result);
if ($rows != 0) {
while ($row = mysql_fetch_array($result))
{
echo " [".showdate("newsdate", $row["news_datestamp"])."] ".$row['news_subject']."
";
}
} else {
echo "Brak danych do wyświetlenia w statystykach";
}
closetable();