query("
SELECT c.*,
(SELECT image_path FROM car_images WHERE car_id = c.id AND is_primary = 1 LIMIT 1) as primary_image,
(SELECT GROUP_CONCAT(image_path ORDER BY display_order SEPARATOR '|') FROM car_images WHERE car_id = c.id) as all_images
FROM cars c
WHERE c.featured = 1 AND c.status = 'available'
ORDER BY c.created_at DESC
");
$featuredCars = $stmt->fetchAll();
} catch (PDOException $e) {
error_log("Error fetching featured cars: " . $e->getMessage());
$featuredCars = [];
}
$pageTitle = 'Special Offers';
include 'includes/header.php';
?>
⭐ Special Offers
Featured Vehicles with Exclusive Deals
🚗
No Special Offers Available
Check back soon for exclusive deals on quality vehicles.