L’AMAP Légumes | Notre producteur partenaire | Les distributions | Actualités |
[insert_php]
global $wpdb;
$wpdb->show_errors();
$Amap=3;
$Nbl=23;
$sql = “SELECT * FROM distributions,contrats , amap where distributions.Amap_id = amap.Amap_Id and distributions.contrat_id = contrats.contrat_id and distributions.Amap_Id =”;
$sql = $sql .$Amap. ” and contrats.CONTRAT_DFIN > SYSDATE() ORDER BY `distributions`.`DISTRIB_DATE` ASC LIMIT “.$Nbl;
$Distrib_pains= $wpdb->get_results($sql);
$Amap=2;
$Nbl=23;
$PermMax=1;
$sql = “SELECT * FROM distributions,contrats , amap where distributions.Amap_id = amap.Amap_Id and distributions.contrat_id = contrats.contrat_id and distributions.Amap_Id =”;
$sql = $sql . $Amap .” and contrats.CONTRAT_DFIN > SYSDATE() ORDER BY `distributions`.`DISTRIB_DATE` ASC LIMIT “.$Nbl;
$Distrib_oeufs = $wpdb->get_results($sql);
echo ‘
echo ‘
Date | Pains | Oeufs | Nom | |
---|---|---|---|---|
‘.$PDate.’ | ‘.$pain.’ | ‘.$oeuf.’ | ? | ‘.$Perm->ADHERENT_PRENOM.’ ‘.$Perm->ADHERENT_NOM.’ |