[PHP] Removing Invalid Users

2001-07-04 Thread Clayton Dukes
Howdy folks, How can I write code that will search the database and check the validity of an email address, and if it's bad, to remove that entry from the database? Here's a dump one of the tables: INSERT INTO users VALUES (1,'','username','[EMAIL PROTECTED]','','','001.gif','Jul 04,

Re: [PHP] Removing Invalid Users

2001-07-04 Thread Tom Carter
, July 04, 2001 7:16 PM Subject: [PHP] Removing Invalid Users Howdy folks, How can I write code that will search the database and check the validity of an email address, and if it's bad, to remove that entry from the database? Here's a dump one of the tables: INSERT INTO users VALUES (1

Re: [PHP] Removing Invalid Users

2001-07-04 Thread Steve Werby
Clayton Dukes [EMAIL PROTECTED] wrote: How can I write code that will search the database and check the validity of an email address, and if it's bad, to remove that entry from the database? Like Tom said, use regex to check the email is of a valid format. A small percentage of servers can be

Re: [PHP] Email verification (was: [PHP] Removing Invalid Users)

2001-07-04 Thread Arcady Genkin
Steve Werby [EMAIL PROTECTED] writes: Arcady Genkin [EMAIL PROTECTED] wrote: If I understand correctly, vrfy does not wholy depend on that functionality to be supported by the server. I think that it simply connects to the smtp port of the mail exchanger and emulates an email delivery,

Re: [PHP] Email verification (was: [PHP] Removing Invalid Users)

2001-07-04 Thread Steve Werby
Arcady Genkin [EMAIL PROTECTED] wrote: If I understand correctly, vrfy does not wholy depend on that functionality to be supported by the server. I think that it simply connects to the smtp port of the mail exchanger and emulates an email delivery, aborting halfway. I hadn't used the tool

Re: [PHP] Email verification (was: [PHP] Removing Invalid Users)

2001-07-04 Thread Steve Werby
Matthew Loff [EMAIL PROTECTED] wrote: There really isn't any surefire way to verify whether an e-mail exists or not, except to try to send to it, correct? Bingo. And with catchall accounts and unexpected mail server behavior you may get no response even if an email address is not valid. IMO,

Re: [PHP] Email verification (was: [PHP] Removing Invalid Users)

2001-07-04 Thread Steve Werby
Steve Werby [EMAIL PROTECTED] writes: Like Tom said, use regex to check the email is of a valid format. A small percentage of servers can be contacted to find whether an email address is valid, but fewer and fewer are allowing this so it's completely unreliable. Arcady Genkin [EMAIL

Re: [PHP] Email verification (was: [PHP] Removing Invalid Users)

2001-07-04 Thread Arcady Genkin
Steve Werby [EMAIL PROTECTED] writes: So unfortunately vrfy will only be useful when checking servers that haven't disabled that command. :-( If I understand correctly, vrfy does not wholy depend on that functionality to be supported by the server. I think that it simply connects to the

RE: [PHP] Email verification (was: [PHP] Removing Invalid Users)

2001-07-04 Thread Matthew Loff
:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 12:06 AM To: Arcady Genkin Cc: Clayton Dukes; [EMAIL PROTECTED] Subject: Re: [PHP] Email verification (was: [PHP] Removing Invalid Users) Steve Werby [EMAIL PROTECTED] writes: Like Tom said, use regex to check the email is of a valid format

[PHP] Email verification (was: [PHP] Removing Invalid Users)

2001-07-04 Thread Arcady Genkin
Steve Werby [EMAIL PROTECTED] writes: Clayton Dukes [EMAIL PROTECTED] wrote: How can I write code that will search the database and check the validity of an email address, and if it's bad, to remove that entry from the database? Like Tom said, use regex to check the email is of a