Site News
$mysql_table = "news";
$query = "select date_format(date, '%W %M %d, %Y')as date , title, text from news order by news.date desc";
$result = $database->query($query);
$rows= $database->rows();
$i=0;
if(! $rows) print " Oops no NEWS";
else
{
while ($rows > $i)
{
$title = $database->get_field($i, "title");
$text= $database->get_field($i, "text");
$date= $database->get_field($i, "date");
print "
"; if($date != $last_date) { print "
\n"; $newday=1; } else { $newday=0; } $last_date=$date; print "$title
$text
\n"; $i++; } } ?>
"; if($date != $last_date) { print "
$date
\n"; $newday=1; } else { $newday=0; } $last_date=$date; print "$title
$text
\n"; $i++; } } ?>