require('dbconnect.php');
$title = "Papers & Abstracts";
require('header.php');
?>
Online papers
$query = "SELECT * FROM articles, categories WHERE online!='' AND articles.category=categories.nr ORDER BY articles.category,year DESC";
$result = mysql_query($query);
$cat = "";
$x = 1;
$year = "9999";
while($resultaat = mysql_fetch_array($result))
{
if($cat!=$resultaat["category_name"]) {
echo "".$resultaat["category_name"]."
";
$x = 1;
$year = "9999";
$cat = $resultaat["category_name"];
}
echo "";
echo "
".$x.".
";
echo "
";
echo "
";
if($year!=$resultaat["year"]) {
echo $resultaat["year"];
$year = $resultaat["year"];
}
echo "
";
echo "
";
$x++;
}
?>
require('footer.php'); ?>