943,726 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 13782
  • MySQL RSS
Jun 10th, 2005
0

how to create mailing list

Expand Post »
How can a band create a mialing list to send out show responses
thanks
rob
Similar Threads
Reputation Points: 10
Solved Threads: 0
Unverified User
bucwyld is offline Offline
10 posts
since Jun 2005
Jun 13th, 2005
0

Re: how to create mailing list

you need to create a table, ie this would be an example:

MySQL Syntax (Toggle Plain Text)
  1. CREATE TABLE email_list (
  2. email VARCHAR(75) NOT NULL,
  3. name VARCHAR(75) NOT NULL,
  4. PRIMARY KEY(email)
  5. );

then just loop through it in whatever language you are usign and email it off to:
name <email>
Reputation Points: 13
Solved Threads: 4
Posting Whiz
paradox814 is offline Offline
351 posts
since Oct 2004
Jun 18th, 2005
0

Re: how to create mailing list

Quote originally posted by bucwyld ...
How can a band create a mailing list to send out show responses
I'm actually not an expert on maillists, but there are specialized apps designed just for this purpose. Some mail servers have built in support of maillists. For example, I use Xmail on my Linux web server. Xmail has a maillist feature, although I've not used it yet.

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.
  1. How many people do you expect to have on your list? If less than 5,000 or so, a text file should work fine.
  2. 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.
If you will have 10's of thousands of subscribers or you know how to work with a database, the database is a better way to go.

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!
Reputation Points: 36
Solved Threads: 6
Posting Whiz
Troy is offline Offline
354 posts
since Jun 2005
Jun 21st, 2005
0

Re: how to create mailing list

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
Reputation Points: 36
Solved Threads: 6
Posting Whiz
Troy is offline Offline
354 posts
since Jun 2005
Feb 24th, 2007
0

Re: how to create mailing list

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
Reputation Points: 10
Solved Threads: 0
Light Poster
egboy is offline Offline
26 posts
since Apr 2005
Mar 2nd, 2007
0

Re: how to create mailing list

Query to find the 10th maximum salary from an employees table which contains empno,empname,empsal as columns.If this table contains n number of records,how to determine the 10th maximum salary
Reputation Points: 10
Solved Threads: 0
Newbie Poster
GTHD is offline Offline
1 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: What's wrong with my query?
Next Thread in MySQL Forum Timeline: A mysql select question.





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC