';
}
}
// Fetch related data for forms
$fuel_types = $pdo->query("SELECT id, name FROM fuel_types ORDER BY name")->fetchAll(PDO::FETCH_ASSOC);
// Fetch all price history with fuel type name
$stmt = $pdo->query("
SELECT ph.id, ph.price, ph.date, ft.name AS fuel_type_name
FROM price_history ph
JOIN fuel_types ft ON ph.fuel_type_id = ft.id
ORDER BY ph.date DESC, ft.name
");
$price_history = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>