103 Posts
Osep45
6 years ago
1
Topic

Hi,

Is it possible to add a field value in a "sql query" (live value of a field) ?

I have try that, for example, but it doesn't work with the field value :

SELECT `#__users`.`email`
FROM `#__users`
INNER JOIN `#__user_usergroup_map` ON `#__user_usergroup_map`.`user_id` = `#__users`.`id`
INNER JOIN `#__usergroups` ON `#__user_usergroup_map`.`group_id` = `#__usergroups`.`id`
INNER JOIN `#__cck_store_form_membres` ON `#__cck_store_form_membres`.`id` = `#__users`.`id`
WHERE `#__usergroups`.`parent_id`='100'
AND `#__cck_store_form_membres`.`membres_roles` IN (". $uri->getValue('messagegroupe_liste_diffusion') .")