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);
