\n| ".$article['article_subject']." |
".$category." |
".$a_author." |
".$article['article_reads']." |
".$article['article_datestamp']." | \n\n
| ".$article['article_snippet']." |
";
return $display_article;
}
opentable($locale['ALP_001']);
$most_recent_articles = dbquery("SELECT * FROM ".$db_prefix."articles ORDER BY article_id DESC");
echo "\n\n";
if (dbrows($most_recent_articles)) {
// Display headings
echo "
| ".$locale['ALP_002']." |
".$locale['ALP_003']." |
".$locale['ALP_004']." |
".$locale['ALP_005']." |
".$locale['ALP_006']." |
";
// Only display articles that exist
while($article = dbarray($most_recent_articles)) {
if ( $x <= $num_articles ) {
// Calculate date submitted
$article['article_datestamp'] = showdate("forumdate",$article['article_datestamp']);
// Look up Category
$result = dbquery("SELECT article_cat_name FROM ".$db_prefix."article_cats WHERE article_cat_id='".$article['article_cat']."'");
$category = dbresult($result,0);
// Look up Author
$result = dbquery("SELECT user_name FROM ".$db_prefix."users WHERE user_id='".$article['article_name']."'");
$a_author = dbresult($result,0);
// Display articles
echo display_articles($article,$category,$a_author);
$x++;
}
}
} else {
echo "".$locale['ALP_007']." |
";
}
echo "
";
closetable();
tablebreak();
?>