mailRe: [Galette-discussion] totalisation des contributions (# 737)


Others Months | Index by Date | Thread Index
>>   [Date Prev] [Date Next] [Thread Prev] [Thread Next]

Header


Content

Posted by Johan Cwiklinski on May 11, 2014 - 10:08:
Salut,

Le 08/05/2014 18:05, André Lefranc a écrit :
qui recherche sur la date enregistrement : (date_enreg)

La requête effectuée par Galette n'est pas basée sur la date
d'enregistrement :
SELECT `a`.*, `p`.* FROM `galette_cotisations` AS `a` INNER JOIN
`galette_adherents` AS `p` ON `a`.`id_adh`= `p`.`id_adh` WHERE
`date_debut_cotis` >= '2014-04-01' AND `date_debut_cotis` <=
'2014-04-30' ORDER BY `date_enreg` DESC LIMIT 10 OFFSET 0

++
-- 
Johan

Attachment: signature.asc
Description: OpenPGP digital signature


Related Messages


Powered by MHonArc, Updated Sun May 11 10:20:08 2014