| | |
how to create mailing list
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
you need to create a table, ie this would be an example:
then just loop through it in whatever language you are usign and email it off to:
name <email>
MySQL Syntax (Toggle Plain Text)
CREATE TABLE email_list ( email VARCHAR(75) NOT NULL, name VARCHAR(75) NOT NULL, PRIMARY KEY(email) );
then just loop through it in whatever language you are usign and email it off to:
name <email>
•
•
•
•
Originally Posted by bucwyld
How can a band create a mailing list to send out show responses
As paradox814 suggested, you can "roll your own" using a database or even a simple text file. Whether to use a database or a text file depends on 2 factors really.
- How many people do you expect to have on your list? If less than 5,000 or so, a text file should work fine.
- Do you already have access to a database? If not, figuring out how to get one setup and how to work with it can be daunting to a newbie to say the least. So if you don't already have a database, then a text file looks attractive.
So being able to manage the data is one thing. Another important part of many maillists is the ability to subscribe or remove yourself. You probably want that, too. So whether you end up using a db or a text file, you'd want to develop a web page front end that allows people to add or remove themselves from the maillist.
Sending a mass mail is then just a case of writing a program to loop through the addresses sending your email to each one. This gives you an overview of your options. Once you decide to code something, I'm sure you'll have plenty more questions!
Enjoy the journey!
bucwyld, came across this yesterday. This guy seems to have some nice, robust code. He has a PHP mailling list solution. Check it out.
http://www.bitfolge.de/morephp-en.html
http://www.bitfolge.de/morephp-en.html
•
•
Join Date: Apr 2005
Posts: 26
Reputation:
Solved Threads: 0
Hi Troy,
Thanks for this script, i tried it, but i think it failed.
i applied every thing on it and this was the result
http://www.zmsh.org/list.php
if their is some thing i have to do, please tell me with it
Thanks for this script, i tried it, but i think it failed.
i applied every thing on it and this was the result
http://www.zmsh.org/list.php
if their is some thing i have to do, please tell me with it
![]() |
Similar Threads
- Newbie php question. how to create a mailing list? (MySQL)
- Need help with php mailing list/redirect (PHP)
- Help with contact/mailing list database design... (Database Design)
- Website Design & Template + mailing list manager (Web Development Job Offers)
- Mailing list script (Growing an Online Community)
Other Threads in the MySQL Forum
- Previous Thread: What's wrong with my query?
- Next Thread: A mysql select question.
| Thread Tools | Search this Thread |
agplv3 amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization





