0 ? ceil($total_records / $per_page) : 1; if($page > $total_pages) { $page = $total_pages; $offset = ($page - 1) * $per_page; } // Fetch Listings $query = "SELECT l.*, li.image_path FROM listings l LEFT JOIN listing_images li ON l.id = li.listing_id AND li.is_primary = 1 WHERE $where_sql ORDER BY l.listing_type = 'featured' DESC, l.created_at DESC LIMIT ? OFFSET ?"; $params[] = $per_page; $params[] = $offset; $types .= "ii"; $stmt = mysqli_prepare($conn, $query); mysqli_stmt_bind_param($stmt, $types, ...$params); mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); ?>