prepare("SELECT marca FROM marche");
$marche->execute();
if (empty($_GET["marca"])) {
$prepare = $connection->prepare("SELECT Codice, Modello, Marca, Prezzo FROM orologi ORDER BY Marca");
} else {
$marca = $_GET["marca"];
$prepare = $connection->prepare("SELECT Codice, Modello, Marca, Prezzo FROM orologi WHERE Marca = ? ORDER BY Marca");
$prepare->bindParam(1, $marca);
}
$prepare->execute();
$connection = null;
} catch (PDOException $e) {
die ("Error!: " . $e->getMessage() . " ");
}
?>
HTML