[thelist] php add email to a mysql db

[Rich Gray]

Andrew
So does this not work?
Rich

<TR><TD>E-mail Address</TD><TD><input name="email" size="30"></TD></TR>
<TR><TD>Subscribe?</TD><TD><input type="checkbox"
name="subscribe"></TD></TR>

And in the PHP code...

<?

if (isset($_POST['subscribe'])) {
	// Do the database stuff
}
?>
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes
Sent: 13 August 2002 10:42
To: thelist at lists.evolt.org
Subject: RE: [thelist] php add email to a mysql db


Hi Rich

Basically I have an order form that submits client info and I want to give
the
user the option to subscribe to a newsletter, the email is already in the
form

<TR><TD>E-mail Address</TD><TD><input name="email" size="30"></TD></TR>

The form at the moments inserts the email into a mysql database without
asking
if the visitor wants to be join the db for future newsletters, so a tick box
would be the best thing.  Unfortunately the same email field is also being
used
to send the visitor a confirmation of their order so I am not sure what is
the
best way forward on this one?  Maybe forget about the tick box!

Thank you

Andrew

PS  Is everyone else getting two of the same posts or is just me?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02

--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !