Hi,
I have this MySQL command:
For reference, please look the topic About a SELECT command to execute in my MysQL Database.Code:SELECT customers.cust_email FROM customers INNER JOIN cust_packages ON cust_packages.cpack_usernr = customers.cust_custnr GROUP BY customers.cust_email HAVING COUNT(cust_packages.cpack_usernr) = COUNT(NULLIF(COALESCE(cpack_canceldate,'0000-00-00'),'0000-00-00'))
Now, I need a script to send one message to all emails selected from the above command.
Thanks.





Bookmarks