Notification sistem
Posted: 2020-11-23 23:29
Hello
I try to make a notification sistem.
I have made a table with Name and E_mail and a CHECKBOX:
Emil [email protected]
I have added the automatically email sending code after insert to /hooks folder to the table file and at email recipients i put $notifications
When i check the box it is 1 in the db. So i search like this :
When i have only one line with one email it works. When i check the box it is sending the email and when i disable the box it does not send the email.
The problem is then i have 2 or more lines with emails:
Emil [email protected]
Marius [email protected]
Ema [email protected]
So i need to request: [email protected], [email protected], [email protected]
I have tryed with : but no luck...
Can anyone help me with the corect $notifications request? i need to recive [email protected], [email protected], [email protected] from the request.
Thank you.
I try to make a notification sistem.
I have made a table with Name and E_mail and a CHECKBOX:
Emil [email protected]
I have added the automatically email sending code after insert to /hooks folder to the table file and at email recipients i put $notifications
When i check the box it is 1 in the db. So i search like this :
Code: Select all
$notifications =sqlValue("SELECT E_mail FROM Notifications where CHECKBOX='1'");The problem is then i have 2 or more lines with emails:
Emil [email protected]
Marius [email protected]
Ema [email protected]
So i need to request: [email protected], [email protected], [email protected]
I have tryed with :
Code: Select all
$notifications =sqlValue("SELECT E_mail,+', ' FROM Notifications where CHECKBOX='1'");Can anyone help me with the corect $notifications request? i need to recive [email protected], [email protected], [email protected] from the request.
Thank you.