- XDB::iterator("SELECT a.id, a.titre AS title, a.texte, a.contacts,
- a.create_date AS publication,
- FIND_IN_SET('photo', a.flags) AS photo,
- CONCAT({?}, '/#art', a.id) AS link
- FROM groupex.announces AS a
- WHERE peremption >= NOW() AND a.asso_id = {?}",
+ XDB::iterator("SELECT id, titre AS title, texte, contacts,
+ create_date AS publication,
+ FIND_IN_SET('photo', flags) AS photo,
+ CONCAT({?}, '/#art', id) AS link
+ FROM group_announces
+ WHERE expiration >= NOW() AND asso_id = {?}",