$total_sql = $bdd->prepare("
                                                SELECT total, date
                                                FROM table_commande
                                                WHERE paiement != :paiement
                                                AND  DATEDIFF(CURDATE(),`date`)<=365 AND CURDATE()>`date`
                                                ");

//la condition CURDATE()>`date` permet d'exclure les lignes dont les dates sont dans le futur

$total_sql = $bdd->prepare("
						SELECT total, date
						FROM table_commande
						WHERE paiement != :paiement
						AND (CURDATE() - date)<= 365
						");
$total_sql->execute(array(
						'paiement' => 0
						));
$total_sql->setFetchMode(PDO::FETCH_ASSOC);

// $prixtotal_au_clic = 0;			
// $nb_commandes_au_clic = 0;
while( $total = $total_sql->fetch() )
{
	echo $total['total'];
}