Merhaba arkadaşlar,

Tablo çizdim ve bu tabloda "İçerik Başlığı - Ekleyen - Eklenme Tarihi " başlıkları var.

İçerik başlığı altına içerik başlığı geliyor fakat bir türlü Ekleyen ve Eklenme Tarihini buraya çekemedim.

Aynısı articles.php'de var.



Yaptığım blok:

openside("Eklenen Son İçerikler");
require_once BASEDIR."maincore.php";
$qresult=dbquery("SELECT * FROM ".DB_ARTICLES." ORDER BY article_datestamp DESC LIMIT 0,50");
if(dbrows($qresult)!=0){
echo "<table style='width: 100%' height='28'>
   <tr>
      <td bgcolor='#EAEAEA' style='width: 330px'>&nbsp;İçerik Başlığı</td>
      <td bgcolor='#EAEAEA' style='width: 224px'>&nbsp; Ekleyen&nbsp;</td>
      <td bgcolor='#EAEAEA'>&nbsp;Eklenme Tarihi</td>
   </tr>
</table>
 
";
echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">";
while($data=dbarray($qresult)){
echo "
";
echo "<tr>\n<td class='side' align='left'>".THEME_BULLET."<a href='".BASEDIR."readarticle.php?article_id=".$data['article_id']."' title='".$data['article_subject']."' class='side'> ";
echo trimlink($data['article_subject'], 30)."</a></td>\n</tr>\n";
}
echo "</table>";
}
closeside();

Articles.php

 
<?php 
require_once "maincore.php"; 
require_once THEMES."templates/header.php"; 
include LOCALE.LOCALESET."articles.php"; 
add_to_title($locale['global_200'].$locale['400']); 
if ($settings['tinymce_enabled'] == 1) echo "<script language='javascript' type='text/javascript'>advanced();</script>\n"; 
if (isset($_GET['article_id']) && isnum($_GET['article_id'])) { 
$result = dbquery( 
"SELECT ta.*,tac.*, tu.user_id,user_name FROM ".DB_ARTICLES." ta 
INNER JOIN ".DB_ARTICLE_CATS." tac ON ta.article_cat=tac.article_cat_id 
LEFT JOIN ".DB_USERS." tu ON ta.article_name=tu.user_id 
WHERE ".groupaccess('article_cat_access')." AND article_id='".$_GET['article_id']."' AND article_draft='0'" 
); 
if (dbrows($result)) { 
require_once INCLUDES."comments_include.php"; 
require_once INCLUDES."ratings_include.php"; 
$data = dbarray($result); 
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; } 
if ($_GET['rowstart'] == 0) { $result = dbquery("UPDATE ".DB_ARTICLES." SET article_reads=article_reads+1 WHERE article_id='".$_GET['article_id']."'"); } 
$article = stripslashes($data['article_article']); 
if (ereg('<--PAGEBREAK-->', $article)) { 
$article = explode("<--PAGEBREAK-->", $article); 
} else { 
$article = explode("<!-- pagebreak -->", $article); 
} 
$pagecount = count($article); 
$article_subject = stripslashes($data['article_subject']); 
$article_info = array( 
"article_id" => $data['article_id'], 
"user_id" => $data['user_id'], 
"user_name" => $data['user_name'], 
"article_date" => $data['article_datestamp'], 
"article_breaks" => $data['article_breaks'], 
"article_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='A' AND comment_item_id='".$data['article_id']."'"), 
"article_reads" => $data['article_reads'], 
"article_allow_comments" => $data['article_allow_comments'] 
); 
add_to_title($locale['global_201'].$article_subject); 
echo "<!--pre_article-->"; 
render_article($article_subject, $article[$_GET['rowstart']], $article_info); 
echo "<!--sub_article-->"; 
if ($pagecount > 1) { 
echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], 1, $pagecount, 3, FUSION_SELF."?article_id=".$_GET['article_id']."&amp;")."\n</div>\n"; 
} 
if ($data['article_allow_comments']) { showcomments("A", DB_ARTICLES, "article_id", $_GET['article_id'], FUSION_SELF."?article_id=".$_GET['article_id']); } 
if ($data['article_allow_ratings']) { showratings("A", $_GET['article_id'], FUSION_SELF."?article_id=".$_GET['article_id']); } 
} else { 
redirect(FUSION_SELF); 
} 
} elseif (!isset($_GET['cat_id']) || !isnum($_GET['cat_id'])) { 
opentable($locale['400']); 
echo "<!--pre_article_idx-->\n"; 
$rows = dbrows($result); 
if ($rows) { 
$counter = 0; $columns = 2; 
echo "<table cellpadding='0' cellspacing='0' width='100%' border='1' bordercolor='#d4d4d4'>\n<tr>\n"; 
while ($data = dbarray($result)) { 
if ($counter != 0 && ($counter % $columns == 0)) { echo "</tr>\n<tr>\n"; } 
$num = dbcount("(article_cat)", DB_ARTICLES, "article_cat='".$data['article_cat_id']."' AND article_draft='0'"); 
echo "<td valign='top' width='50%' class='tbl article_idx_cat_name'><!--article_idx_cat_name--><a href='".FUSION_SELF."?cat_id=".$data['article_cat_id']."'>".$data['article_cat_name']."</a> <span class='small2'>($num)</span>"; 
if ($data['article_cat_description'] != "") { echo "\n<span class='small'>".$data['article_cat_description']."</span>"; } 
echo "</td>\n"; 
$counter++; 
} 
echo "</tr>\n</table>\n"; 
} else { 
echo "<div style='text-align:center'>\n".$locale['401']."\n</div>\n"; 
} 
echo "<!--sub_article_idx-->\n"; 
closetable(); 
} else { 
$res = 0; 
$result = dbquery("SELECT * FROM ".DB_ARTICLE_CATS." WHERE article_cat_id='".$_GET['cat_id']."'"); 
if (dbrows($result) != 0) { 
$cdata = dbarray($result); 
if (checkgroup($cdata['article_cat_access'])) { 
$res = 1; 
add_to_title($locale['global_201'].$cdata['article_cat_name']); 
opentable($locale['400'].": ".$cdata['article_cat_name']); 
echo"<table width='100%' border='0' bgcolor='#D9D9D9' height='10'>
<tr>
<td>İnceleme Başlığı </td>
</tr>
</table>
";
echo "<!--pre_article_cat-->"; 
$rows = dbcount("(article_id)", DB_ARTICLES, "article_cat='".$_GET['cat_id']."' AND article_draft='0'"); 
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; } 
if ($rows != 0) { 
$result = dbquery( 
"SELECT ta.article_id, ta.article_subject, ta.article_snippet, ta.article_datestamp FROM ".DB_ARTICLES." ta 
WHERE article_cat='".$_GET['cat_id']."' AND article_draft='0' ORDER BY ".$cdata['article_cat_sorting']." LIMIT ".$_GET['rowstart'].",15" 
); 
$numrows = dbrows($result); $i = 1; 
echo "<table cellpadding='0' cellspacing='0' width='100%' border='1' bordercolor='#d4d4d4'>\n"; 
while ($data = dbarray($result)) { 
if ($data['article_datestamp'] + 604800 > time() + ($settings['timeoffset'] * 3600)) { 
$new = "<span class='small'>[".$locale['402']."]</span>"; 
} else { 
$new = ""; 
} 
echo "<tr><td><a href='".FUSION_SELF."?article_id=".$data['article_id']."'>".$data['article_subject']."</a>$new\n </td></tr>"; 
echo ($i != $numrows ? "\n" : "\n"); $i++; 
} 
echo "</table><!--sub_article_cat-->"; 
closetable(); 
if ($rows > 15) echo "<div align='center' style=';margin-top:0px;'>\n".makepagenav($_GET['rowstart'], 15, $rows, 3, FUSION_SELF."?cat_id=".$_GET['cat_id']."&amp;")."\n</div>\n"; 
} else { 
echo "<div style='text-align:center'>".$locale['403']."</div>\n"; 
echo "<!--sub_article_cat-->"; 
closetable(); 
} 
} 
} 
if ($res == 0) { redirect(FUSION_SELF); } 
} 
require_once THEMES."templates/footer.php"; 
?>

Birde siz bakarsanız sevinirim, iyi çalışmalar