You have an error in your SQL syntax near 'ORDER BY constructeurs.nom_constructeur ASC' at line 1
SELECT annonces.id_constructeur, constructeurs.nom_constructeur FROM (annonces, constructeurs) WHERE annonces.id_constructeur=constructeurs.id_constructeur AND annonces.id_type_produit= ORDER BY constructeurs.nom_constructeur ASC

You have an error in your SQL syntax near 'ORDER BY prix ASC' at line 1
SELECT prix FROM annonces WHERE id_type_produit= ORDER BY prix ASC

You have an error in your SQL syntax near 'ORDER BY prix DESC' at line 1
SELECT prix FROM annonces WHERE id_type_produit= ORDER BY prix DESC

You have an error in your SQL syntax near 'ORDER BY millesime ASC' at line 1
SELECT millesime FROM annonces WHERE id_type_produit= ORDER BY millesime ASC

You have an error in your SQL syntax near 'ORDER BY millesime DESC' at line 1
SELECT millesime FROM annonces WHERE id_type_produit= ORDER BY millesime DESC