мэдээлэл
if (!isset($_GET["id"]))
{
?>
}
?>
$sql = "SELECT news.*,news_category.name category_name FROM news LEFT JOIN news_category ON news.category = news_category.id ";
if (isset($_GET["category"]))
$sql .= "WHERE category='".intval($_GET["category"])."' AND en=0 ";
else $sql .= "WHERE en=0 ";
$sql .="ORDER BY `date` DESC LIMIT 52";
// echo $sql;
$result = mysqli_query($conn,$sql);
while ($news = mysqli_fetch_array($result))
{
?>
}
?>
}
if (isset($_GET["id"]))
{
$news_id = intval($_GET["id"]);
$sql = "SELECT news.*, news_category.name category_name FROM news LEFT JOIN news_category ON news.category=news_category.id WHERE news.id=$news_id";
$result = mysqli_query($conn,$sql);
$news = mysqli_fetch_array($result);
?>