I love Dreamhost's incorporation of announcement lists, but I'd like to take it a step further. I know that they maintain a script to automatically add users to the list, but my site is totally PHP and I'd like it to be manageable through the administration interface I've designed. I want users to be able to sign up for lists, and I want my administrators to be able to remove, edit and add members from the website.
So, I'm wondering...do you think it would be a bad idea to just make my own little system using PHP and MySQL, storing email addresses in the database, and then using PHP to send a message via mail() to each email address in the database? I'm assuming it's not a really good idea, but I'd really like subscription to be accessible through my website using my own systems.
So, basically, my question is: is there a good way to do this in PHP, or is it possible to create my own interface to add information to the DH program?