User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,454 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,248 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 6633 | Replies: 5
Reply
Join Date: Jun 2005
Posts: 10
Reputation: bucwyld is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
bucwyld bucwyld is offline Offline
Newbie Poster

how to create mailing list

  #1  
Jun 10th, 2005
How can a band create a mialing list to send out show responses
thanks
rob
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Oct 2004
Location: San Francisco, CA
Posts: 338
Reputation: paradox814 is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 2
paradox814's Avatar
paradox814 paradox814 is offline Offline
Posting Whiz

Re: how to create mailing list

  #2  
Jun 13th, 2005
you need to create a table, ie this would be an example:

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>
Reply With Quote  
Join Date: Jun 2005
Location: Kansas City, Missouri, USA
Posts: 344
Reputation: Troy is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 4
Troy's Avatar
Troy Troy is offline Offline
Posting Whiz

Re: how to create mailing list

  #3  
Jun 17th, 2005
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!
Troy Wolf is the author of SnippetEdit. "Website editing as easy as it gets." IX Web Hosting
Reply With Quote  
Join Date: Jun 2005
Location: Kansas City, Missouri, USA
Posts: 344
Reputation: Troy is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 4
Troy's Avatar
Troy Troy is offline Offline
Posting Whiz

Re: how to create mailing list

  #4  
Jun 21st, 2005
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
Reply With Quote  
Join Date: Apr 2005
Posts: 24
Reputation: egboy is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
egboy egboy is offline Offline
Newbie Poster

Re: how to create mailing list

  #5  
Feb 24th, 2007
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
Reply With Quote  
Join Date: Mar 2007
Posts: 1
Reputation: GTHD is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
GTHD GTHD is offline Offline
Newbie Poster

Re: how to create mailing list

  #6  
Mar 2nd, 2007
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
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MySQL Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MySQL Forum

All times are GMT -4. The time now is 3:23 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC