- $res = XDB::iterRow(
- 'SELECT u.prenom,
- IF(u.nom_usage = \'\',u.nom,u.nom_usage) AS nom,
- u.promo,
- u.naissance,
- DATE_ADD(u.naissance, INTERVAL 1 DAY) AS end,
- u.date_ins,
- u.hruid
- FROM contacts AS c
- INNER JOIN auth_user_md5 AS u ON (u.user_id = c.contact)
- INNER JOIN aliases AS a ON (u.user_id = a.id AND a.type = \'a_vie\')
- WHERE c.uid = {?}', $user->id());
-