query("SELECT blog_topics.topic_name, blog_topics.topic_topic_id, blog_topics.topic_front_text, blog_topics.topic_slug, blog_topics.topic_date, blog_topics.topic_home_img, blog_categories.category_name, blog_categories.category_slug FROM blog_topics LEFT JOIN blog_categories ON blog_categories.category_category_id = blog_topics.topic_category_id AND blog_categories.category_lang_id = ? WHERE blog_categories.category_slug = ? AND blog_topics.topic_status = ? AND blog_topics.topic_lang_id = ? ", array($site_lang,$_GET['kategori'],'2',$site_lang)); } } else { $blogs = $Db->query("SELECT blog_topics.topic_name, blog_topics.topic_topic_id, blog_topics.topic_front_text, blog_topics.topic_slug, blog_topics.topic_date, blog_topics.topic_home_img, blog_categories.category_name, blog_categories.category_slug FROM blog_topics LEFT JOIN blog_categories ON blog_categories.category_category_id = blog_topics.topic_category_id AND blog_categories.category_lang_id = ? WHERE blog_topics.topic_status = ? AND blog_topics.topic_lang_id = ?", array($site_lang,'2',$site_lang)); } $cats = $Db->query("SELECT category_name,category_slug FROM blog_categories WHERE category_lang_id = ? AND category_status = ? ", array($site_lang,'2',$site_lang)); $latests = $Db->query("SELECT topic_name, topic_slug, topic_date, topic_home_img FROM blog_topics WHERE topic_status = ? AND topic_lang_id = ? ORDER BY topic_topic_id DESC LIMIT 4", array('2',$site_lang)); $page_data = $Db->row("SELECT * FROM page_blog WHERE page_lang_id = ?", array($site_lang)); ### Hitcounter $pagename = "Türkçe Blog"; include_once("../hit_counter.php"); ### Hitcounter ?> <?php echo $page_data['page_title']; ?>

row("SELECT COUNT(comment_id) AS comm FROM blog_comments WHERE comment_topic_id = ? AND comment_status = ? ", array($blog['topic_topic_id'],'2')); ?>

Kategoriler