include './includes/config.php'; $categoryID = $_GET['snr']; if(isset($categoryID)){ $sql_list = "SELECT projects.*, project_images.image_name, category.id AS category_id FROM projects JOIN category ON category.id = projects.project_category JOIN project_images ON projects.id = project_images.project_id WHERE project_images.image_type = 'project_thumb' AND category.category_nameC='$categoryID' ORDER BY projects.project_class DESC"; $result_list = mysqli_query($con, $sql_list); }else{ $sql_list = "SELECT projects.*, project_images.image_name FROM projects JOIN project_images ON projects.id = project_images.project_id WHERE project_images.image_type = 'project_thumb' ORDER BY projects.project_class DESC "; $result_list = mysqli_query($con,$sql_list); } $sql_settings = "SELECT projectsCover from settings WHERE id='1'"; $result_settings = mysqli_query($con,$sql_settings); $row_settings = mysqli_fetch_assoc($result_settings); ?>