$query = "SELECT * FROM prodotti ORDER by 'campo1' DESC&& 'campo2' && 'campo3' ASC";

E' sbagliata la query....

$query = "SELECT * FROM prodotti ORDER BY campo1 DESC, campo2 ASC, campo3 ASC