function get_list_question_same_category($news_data, $limit = 5, $prepare = true) { $db_query = new db_query('SELECT que_id, que_title, que_question_content, que_image, que_view, que_date, "' . $news_data['cat_name'] . '" AS cat_name FROM questions WHERE que_cat_id = ' . $news_data['que_cat_id'] . ' AND que_date <= ' . $news_data['que_date'] . ' AND que_status = 1 AND que_type = 0 AND que_id <> ' . $news_data['que_id'] . ' ORDER BY que_date DESC LIMIT ' . $limit); $list_news = array(); while ($row = mysqli_fetch_assoc($db_query->result)) { if ($prepare) { prepare_hoidap_record($row, 'mobile_small'); } $list_news[] = $row; } return $list_news; }
AND que_type = 0 AND que_date <= ' . TIMESTAMP . ' ORDER BY que_date DESC LIMIT ' . $limit_string); } else { $db_query = new db_query('SELECT que_id,que_title,que_question_content,que_image,cat_name FROM questions LEFT JOIN categories ON que_cat_id = cat_id WHERE que_status = 1 AND que_type = 0 AND que_date <= ' . TIMESTAMP . ' ORDER BY que_date DESC LIMIT ' . $limit_string); } while ($row = mysqli_fetch_assoc($db_query->result)) { prepare_hoidap_record($row, 'mobile_small'); ?> <li class="fade-out"> <a class="catehot" href="<?php echo $row['link_detail']; ?> " title="<?php echo $row['que_title']; ?> "> <img class="catehot-thumbnail" src="<?php echo $row['que_image_low']; ?> " alt="<?php echo $row['que_title']; ?>
FROM questions LEFT JOIN categories ON cat_id = que_cat_id WHERE que_type = 0 AND que_status = 1 AND que_id = ' . $que_id . ' LIMIT 1'); $question_data = mysqli_fetch_assoc($db_query->result); unset($db_query); if (!$question_data) { error_404_document(); } prepare_hoidap_record($question_data); //lấy ra câu hỏi cùng chuyên mục $list_cat_news = get_list_question_same_category($question_data, 5, true); //tin hot trong ngày $list_hot_day = array(); $db_news_hot_day = new db_query('SELECT que_id, que_title, cat_name FROM questions LEFT JOIN categories ON cat_id = que_cat_id WHERE que_status = 1 AND que_type = 0 AND que_date >= ' . (TIMESTAMP - 86400) . ' AND que_date <= ' . TIMESTAMP . ' AND que_id <> ' . $que_id . ' ORDER BY que_view DESC LIMIT 0,5'); while ($row = mysqli_fetch_assoc($db_news_hot_day->result)) { prepare_hoidap_record($row); $list_hot_day[] = $row; } unset($db_news_hot_day);