PHP :: Dynamic Mailing List?

Mailing List
I am really interested in putting a mailing list on my website. I have only just discovered php and mysql and I found a program called php list on my cPanel X control panel on my website.

I would like to put a text box on my navigation bar that has inside it "enter your e-mail" (when they click this disappears) and a button on the right of that which says "join" (I will have a jpg underneath this text box saying "Mailing List").

When someone clicks on "join" I would like them to get sent to a page with the e-mail address field filled out in the right table with what the address they entered in the navigation pane, along with a name field they can fill out and a Submit button.

I have seen these on many websites so I assume it is not that hard to do, but I am pretty lost as to how everything is connected (the database (mysql?) and the php list program).

I assume when they click submit it will send their details to a mysql database / send them a confirmation e-mail.

I was wondering what code I will need to make this system work, as I have been reading and googling and I am quite lost as to the mechanics of how it all works.

PHP Mailing List Problem
Here's the problem: I've been trying to send to my mailing list using a PHP script, but the page that executes the send times out before the script can actually send to everyone on the list; only about the first half gets sent to.. Is there any possible way around this or to stop the browser from timing out?

Writing Mailing List In PHP?
what's the best way to write a simple mailing list program? If one tries to send email to over 600 addresses using mail(), a usual script will most likely timeout.

So, the question is, what's the best way to sendout email to over 600 ppl?

Php Mailing List-> Performance
i wrote a php script that sends mail to a list of email generated from a database.
this database contains about 8000 email adresses and depending on what the users chose in their preferences it sends out mail accordingly. in general this would come down to roughly 6000 emails per list.

the script iterates through the list of email addresses and send out a new email to every email address found that fits the mailing type. the box doing this is an athlon 1400Mhz.

now, my question, how heavy will this be for sendmail? i can imagine that this will take some time before all 6000 emails have been send. php is set in the ini to time out after 30 seconds and maybe this script will be running for longer than that with 6000 emails to send. i could test this but i dont think all of those people would be very happy receiving test emails.

also, i could send just one mail with all those email addresses stuffed into the Bcc header but i dont know if that would make difference and if the php mail() function likes 6000 mail addresses in the Bcc header. anyone with experience with sending large volumes of mail like this have some advice for me?

Php Mailing List Operation
I'm using the mail() function to send out newsletters to subscribers,
problem is that it seems a little unreliable...
at the moment I assemble the mail outside a loop then iterate through
all the mail addresses
for($i=0;$i<$numaddresses;$i++){
mail($to[$i],$subj,$message,$fromstr);
}
should i be putting in a delay message or a retry_on_fail method or
anything?

Subscription Mailing List
Im building my first php site and what im looking for is a simple
tutuorial / example of a form which allows users to enter their email
address, which is stored in my Mysql db.

Also need to know how to go about mailing everyone who subscribes to
my news letter.

I know its probably quite simple, but i'd like to check for duplicate
email addresses, verify email addresses (dont know if that possible)
and allow them to un-subcribe.

Mailing List Using MySQL / PHP
I have written a database which uses PHP to run through each ID in the
database and then generate a persons name and address to include into the
rest of the PHP to send an email out.

But as people have deleted or updated their details on this mailing list, I
now have "holes" in database. Ordinarily not a problem, but the code I've
written starts at ID 1 and after sending an email increments to the next
ID. But when it encounters a now vacant ID, it sends an error email to me
associated with that now blank ID row of data.

How can I change my code that will increment through all the results in
turn, but not give me these error emails when people have amended the
database?

Mailing List Script
Where I can find siple mailing list written in php and mysql ?

Timeout Mailing List?
i heave a mailing list with just over 700 people on it. on page one i have a form for newsletter to be typed in, then the person submits the form and the next page has the php to send out the newsletter to all the email addresses in the database.

my problem is that the page times out and an connection error occurs, so i don't think everyone in the list gets emailed. how do i get around this problem?

Php Mailing List Script
I need a php mailing list script, can anyone recommend one? preferably OS if possible.

Making A Mailing List
I have tons of members on my website, and I want to e-mail them all, but I do not want add all their names to a address book or e-mail them individually.

So I was wondering after I flush(Erase) the database, when the user register the "script" will auto adds them to a mailing list, so I can download the mailing list and add it to my address book and e-mail them all at once.

If there is a script already out there, can I have it?

Key Code Generation For Mailing List
I want to send a unique url to each member of my mailing list for mailing list removal purposes. I see this done all the time, but I'm not sure how they do it. I want the user to click on the link at the bottom of their email, which takes them to a page where they confirm there removal from the list.

It doen't have to be super secure, its just a personal site, I just don't want idiots going in and guessing random addressess trying to get them removed from the list.

Remove From Mailing List Via Variables In URL
i have often joined other mailing lists and i notice that when emails are sent out there is usually an option to delete your email from the mailing list.

i was wondering which is the best way to go about this. would it be a matter of sending a link in the email which is something like...

http://wwwmysite.com/deletemail.php?somebody@somewhere.com

deletemail.php being a simple script that takes that email addy and deletes it from the database? or is there a better way to do it?

Duplicate Mail When I Send A Mailing-list
I use mysql and the function mall to send a mailing-list. When I execute my script, certain person receives two or more identical messages. I think that the problem is in the server smtp which does not manage to send all the messages at the same time.

Adding A Mailing List To Vbulletin Registration
I have added yes and no buttons to an option called bsmailinglist in the form for registration on my forums. Now I want to have that answer handled according to the following code. I have the yes button set to TRUE and the no button set to FALSE. After adding the folloing code to the script that handles the form (register.php), I get a parse error on the last line of php, the closing php flag. Code:

function BSwrite ($email) {
$BSfile = "bsmailinglist.txt";
$BSopen = fopen ($BSfile, "a");
if ($BSopen) {
fwrite ($BSopen, "$bsmailinglist, ");
fclose ($BSopen);
} // end BSwrite Function
if ($bsmailinglist) {
BSwrite();
}

Is It Very Difficult To Setup A Simple Mailing List?
I've seen and been on mailing lists where there are a bunch of people on it, but, when you reply to "the list" you are actually replying to something like, "mailinglist@widgets.com". So I want to setup something like this for a special project. I'm imagining that when the server gets an email to "mailinglist" that it would basically just re-send the message to everyone on the list.

Is this very difficult or even advisable using PHP's mail function?

Is There Any Open Source Mailing List Manager That Works Good
I am searching for a good open source php mailing list manager for some days. can any one suggest me one please.

Php Sending Mails To Mailing List Show Strange Headers
i need to send a mail to one mailing list address.when i sent to this the from address comes as newsletter-request@abc.com; on behalf of; ABC[abc@abc.com]
where newsletter@abc.com is the mailing list id abc@abc.com is the moderator id

when i change the to address to any other email address other than this mailing list, the from field works fine. i have given the mailing list, in the Bcc header.

A Dynamic Drop Down List
I need to create a dynamic drop down list. By this i mean that the webpage html form = select style will recieve all the values as based on a query to a mysql database. I have no problems quering the data base with PHP, But i need to make some kind of for loop that will add a new value to the selct form for each result from the database. my thought process go like this.

1. call data base to guery. (no problem)

2. make variable variables that will be created according to the number of results (these variables must be created according to results of query, not a problem i think)

3. make a form like this

<form action = ***** method = post>
<select name = ******>
<option value = "This is a query result"> This is a query result> //This is the part i need to using a for loop and variable variables
</select></form>

so my problem is part 3, cause is this all done in PHP, or if i had all these variables, can i do this in HTML? Can i make a for loop in PHP that would break into HTML during these parts?

Dynamic List Order
I was trying to get the list box to display the id numbers in ascending order however the code below does not work, just wondering how to fix it?

<?php
$g = "SELECT * FROM em ORDER BY iD ASC";
$q = mysql_query($g, $link_id) or die(mysql_error());

if (mysql_num_rows($q) > 0)
{
?>
<select name="d">
<?php
while($r = mysql_fetch_assoc($q))
{
?>
<option value="<?php echo $r['Id']; ?>"><?php echo $r['Id']; ?></option>
<?php
}
}
?>

Dynamic List Population
how do you populate a list dynamically? for example I have the following in a table but I can't get them into the list after the query is performed.

<form action="">
<select name="cars">
<option value="volvo">Volvo</option>
<option value="saab">Saab</option>
<option value="fiat">Fiat</option>
<option value="audi">Audi</option>
</select>

Generating A Dynamic List
I am tying to write a statement that will compare the values of 2 columns, and display the result in a temp table.

ex. Table A has the following columns: "Minimum" and "Maximum." The temp table will hold the reult of the difference between the 2 columns of table A.

Scope: I am trying to crate a drop down with the resulting data as it is incremented. If Min = 2 and Max = 7, the TEMP tab;e should get the results of 2,3,4,5,6,7. I want to have this result displayed in a drop-down list.

Dynamic List Items Repeating Themselves
I'm working on this online magazine, and each page (well, other than the front page) has a menu included on the right-hand side consisting of articles divided into three sections: articles, columns, reviews. For some reason, whenever I click on one of these article links, that link takes the place of the first link in the section. You can see what I mean here: PHP for the included right_menu.php PHP Code:

Dynamic Checkbox List - DB Update
I have a set of questions which are being dynamically output:

for($i=0; $i<count($question_array); $i++)
{echo $question_array[$i][question] .

"<input type='checkbox' name='question_" . $question_array[$i][id] . "' value='Y'' . "><br>";}

I then want to update each question in the DB. I want to loop through each question id and carry out the relevant action (either enable or disable). What is the best way to do this?? As I am dynamically generating the variable name (e.g. question_50) what is the best way to loop through these updating the relevant id?

Dynamic Drop-down List In Array
Q. How do I create a dynamically-generated drop-down list for use in
an array.

I'm using PHP with a MySQL database (through phpMyAdmin)

My database table is called com_courses, and I want to pull the
distinct 'title' fields and have them appear as a drop down menu for
the user to select in a form.

Here is my array, with (at the moment) manually-entered 'titles'
(which I now need to be dynamically generated from my database field:
'com_courses.title'

array (
"coursetitle",
"Course Title:",
$EXTRA_SELECTLIST,

array ("Report Writing", "Recruitment & Selection", "Presentation
Skills", "Essential Telephone Skills", "Time Managememt", "Customer
Care", "Other"),
0
),

I am not an experienced programmer, but can play around with php to
customize programs. I've read up on arrays (I bought a "Programming
with PHP and MySQL" book, but it just stops short of this problem). I
can't figure this one out.

The Dynamic Zone Of List PHP. Please It 's Very Urgent!
I want to create in a form in php two zone of list (A and B).
the options of the zone lists B are dependent on the option chosen in
zone A.

Dynamic Form Option List
I want to create a dynamic drop down option list in a form, but I just can't wrap my head around this.

Both of the below scripts work as intended, but how do I make the mySql query results work with my existing script? Yes, I know I must replace the "$options = array" part in the top piece of code, but I need a little more guidance than that. Code:

Searching Dynamic Driven List
I have a members database will all their personal details in. I have a page running a SQL query to display a complete list of all these people. This is what my query looks like:

$sql_prop = "SELECT * FROM $db.members WHERE area = '".$_REQUEST['area']. "' ORDER BY name ASC;
$result_prop = mysql_query($sql_prop) or die(error_report("Mysql Error", mysql_error()."

$sql_prop", $_SERVER['REMOTE_ADDR']));

"Error Report" is just one of my functions. I have two forms fields on this page, "Name" and "Address". I want to be able to search the listing that this SQL query has returned for those fields, ie. the user enters "John" in the form field and it returns all entries within the query matching "John". The reason I'm using this:

area = '".$_REQUEST['area']. "'
in the WHERE clause, is just to ensure that the person viewing this list can only see members that are in his area. On the previous page there is a piece of code that gets the session "area" and brings it across to this page. I'm keen on keeping that code in. It works for me at the moment.

Any ideas? How can I search this already filtered list?

Dynamic Form - How To Set Values Of A List
I have a form with a list/menu in it that is populated with records from a database. The items in list#2 are based upon what is selected in list#1.

I have been able to use a combination of php and javascript to get it to work, but the javascript reloads the page to get list #2 to refresh - and that clears out any other fields that have been filled in. Instead of javascript being called for the 'onchange' event for list #1, I'd rather it call php when list#1 is changed and so reset the values in list#2.

OPTIONS:
1. I thought I could have a php function that is called (i.e. onchange="<?php reload();?>" but I can't figure out how to set the values of the list from within the php function. How to reference form objects with php?

Dynamic List Populated By MySQL Table
I am building my first php page and I've ran into problems trying to create a dynamic drop down list for an INSERT page. My page is based on this example from mysql.com.

I want to populate the list from a table in MySQL, but when I test the page the list only contains the first record. If anyone can help me out, or recommend an easy way to create dynamic menus/lists, I will be very grateful.

This code appears above the FORM ACTION:

$NearMajorCity = mysql_query("SELECT NearMajorCity_ID, NearMajorCity FROM NearMajorCity");

This code is within the FORM:

<SELECT NAME="NearMajorCity" SIZE=1>
<OPTION SELECTED VALUE="">Select One
<OPTION VALUE="">---------
<?php
while ($NearMajorCity = mysql_fetch_array($NearMajorCity)) {
$NearMajorCity_ID = $NearMajorCity["NearMajorCity_ID"];
$NearMajorCity = $NearMajorCity["NearMajorCity"];
echo("<OPTION VALUE='$NearMajorCity_ID'>$NearMajorCity
");
}
?>
</SELECT>

I want to be able to view the names of the Major Cities in the list, but I want the NearMajorCity_ID inserted into the table.

Member Area With Dynamic File List
I have an Apache 1.3.31 with PHP 4.4.1 available and want to create
some kind of "member area" with a per-user or per-group listing of
files that can be downloaded.

How would I do this?

At present I just protect the individual files using .htaccess
and .htpasswd files and give out direct URLs to the files together with
username/password. What I'd like is some login functionality where
people can log in using their username/password and then find a list of
files they can download together with additional information
individually tailored for that user.

Dynamic Drop-down List With Array - Question
Can anyone out there give me a pointer regarding creating a
dynamically-generated drop-down list connected to an array?

And is that question as clear as chocolate spread?

Here's what I've got. I'm using PHP and MySQL database. I'm customizing
some calendar software, and I want the user to fill in a form by
selecting a title from a drop-down list, generated by my MySQL
database. However, the program I'm customizing uses arrays, which is
where I'm stumped.

What do I need to add to this code to make the array of titles(eg
"report writing" etc) come from my database, rather than the
manually-entered values that you can see here.

The field I want to pull from is called com_courses.title

array (
"coursetitle",
"Course Title:",
$EXTRA_SELECTLIST,

array ("Report Writing", "Recruitment & Selection", "Presentation
Skills", "Essential Telephone Skills", "Time Managememt", "Customer
Care", "Other"),
0
),

I hope it's not cheeky to ask this,
BTW I bought a book on Programming with PHP and MySQL, but it doesn't
answer this question,

List Contents Of A Folder, Make List Of Links
Does anyone know how I can write a script that:

- reads in all the files in a particular directory
- displays the file names in a html list and makes a link of them:
<ul>
<li><a href="filelocation1">filename 1</li>
<li><a href="filelocation2">filename 1</li>
<li><a href="filelocation3">filename 1</li>
</ul>

etc.?

So basically it creates a list of links with the contents in that directory,
so you can download them from there.

Get List Of Messages From One Table, Message List Indicator From
I have two tables. One has a list of messages left by users using fields named mbxno for the mailbox and msgno for the message number. I have another table that has mailbox settings for each user that contains a field named "messagelist" to indicate if they want to be included on the message list or not.

What I'm trying to create is a list of the most-recent messages with a lookup on the users table to indicate whether a message in the list should be included in the message list based on the user's mailbox settings.

SELECT messages.msgno, messages.mbxno, users.messagelist FROM messages, users WHERE (users.messagelist = Ƈ') ORDER BY msgno DESC LIMIT 100

What I'm getting, though is a list that looks like this:

mbxno: 1114 msgno: 0412141623 msglist: 1
mbxno: 1114 msgno: 0412141623 msglist: 1
mbxno: 1114 msgno: 0412141623 msglist: 1
mbxno: 1114 msgno: 0412141623 msglist: 1
mbxno: 1114 msgno: 0412141623 msglist: 1
mbxno: 1114 msgno: 0412141623 msglist: 1
mbxno: 1114 msgno: 0412141623 msglist: 1
mbxno: 1114 msgno: 0412141623 msglist: 1

I think what's happening is that I'm using the wrong type of join and more rows are being created than necessary.

If I add "DISTINCT" to the query, I get a list of the most-recent messages as I expect, but the "messsagelist" value is sometimes wrong (again, probably because the data is getting jumbled). For example, the messagelist value for the second row (2214) should be 0, not 1.

mbxno: 1114 msgno: 0412141623 msglist: 1
mbxno: 2214 msgno: 0412141622 msglist: 1
mbxno: 2189 msgno: 0412141408 msglist: 1
mbxno: 0000 msgno: 0412141213 msglist: 1
mbxno: 0003 msgno: 0412141213 msglist: 1
mbxno: 2265 msgno: 0412132029 msglist: 1
mbxno: 0000 msgno: 0412131950 msglist: 1

How should I be doing this? If nothing else, what kind of join will work with a long list compared to a value from a short list?

Populating A List Box Or A Dropdown List Using Php And Odbc
I need to populate a list box and/or a dropdown list on a form. I have all
the bits and pieces together, all bar the code which takes the result of a
query and creates a list box.

Mailing
Anyone know how to send e-mail using PHP, that I can be sure that every e-mail user will get it?

Now I'm using mail ( ) function and some people can't get this mails, because of security settings of their post system.

My PHP server is based on FreeBSD, and Apache. My post server is sendmail.

Mailing All Users
I am trying to do a mailing script that sends mail to all users, their addresses are stored in a MySQL table. However, I am having an odd problem with the footer....I am having an unsubscribe function which points to an URL with the user's email address in, however all of these footers are getting strung onto the end of each other and printed at the end of each email. Unsetting this footer after each email has sent has made no effect. The code: