[thelist] php email verify weird problem

[Andrew Maynes]

cool, so - mysql_db_query($dbname, "insert into mailinglux
values('','$email')");

should be- mysql_select_db($dbname, "insert into mailinglux
values('','$email')");

?

Thanks for the tick bx stuff, I will put the code in and juggle accordingly!
Thank you kindly.

I have been getitng 2 posts for everyones post!  So I unsubscribed and setup
another mail account but still getting two so something isn't right?  I ahve
mailed admin and haven't heard yet

Andrew Maynes

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Rich Gray
Sent: Wednesday, August 14, 2002 10:15
To: thelist at lists.evolt.org
Subject: RE: [thelist] php email verify weird problem


Andrew,

FYI mysql_db_query is deprecated now in PHP - you should use
mysql_select_db() and mysql_query()

I did post a suggested solution (see below) for the checkbox issue
yesterday... however this was to another guy called Andrew Maynes - who he?
:)
Did you try that?

<<<<<<<<<<<<<<<<<<<<<<
<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
}
?>
<<<<<<<<<<<<<<<<<<<<<<<<<<<

Rich
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Mesnay
Sent: 14 August 2002 09:32
To: thelist at lists.evolt.org
Subject: RE: [thelist] php email verify weird problem


silly silly me, having just pasted the two lots of code I noticed the
problem, I
did think it was something other than this but is was simply this:

$dbname, was omitted from the following.

mysql_db_query($dbname, "insert into mailinglux values('','$email')");


I still have the problem of not incorporatting the tick boxes for this email
submit, and I have seen one of the obvious senarios for this.  If a visitor
returns to make another purchase they aren't going to subscribe to the same
newsletter but will still have the same email address to receive normal
correspondence order confirmation etc, so the tick box is fairly important!

Any ideas how one should go about this?

Andrew

I am still getting 2 of every post and I have tried all sorts to stop it!!
---
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 !

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

---
Incoming 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

---
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