opentable("New Articles");
$result = dbquery("SELECT * FROM ".DB_PREFIX."articles ORDER BY article_datestamp DESC LIMIT 0,10");
$max_chars = 65; // The maximum number of characters to show in each article title
echo "<table width='100%' cellpadding='0' cellspacing='0'>\n";
while ($data = dbarray($result)) {
$title = $data['article_subject'];
$sh_title = $title;
$a_id = $data['article_id'];
$v_id = $data['article_reads'];
$comments_a = dbcount("(comment_id)", "comments", "comment_type='A' AND comment_item_id=$a_id");
$date = $data['article_datestamp'];
$a_date = showdate("%d-%m-%Y", $date);
echo "<tr><td class='tbl' style='border-top:1px #ccc dotted;'> <img src='".THEME."images/bullet.gif' alt=''> $a_date | <a href='".BASEDIR."readarticle.php?article_id=".$data['article_id']."' title='".$data['article_subject']."' class='side'>".trimlink($data['article_subject'], $max_chars)."</a> [$v_id Views]</td></tr>\n";
}
echo "<tr><td align='center' class='tbl' style='border-top:1px #ccc dotted;'><a href='".BASEDIR."articles.php'>All Articles</a></td></tr>\n";
echo "</table>\n";
closetable();
Category Forum
Panels and InfusionsLabels
None yet
Statistics
1 participant
Notifications
You are not receiving notifications from this thread.
Related Questions