Programming Help Forums / PHP / MySQL Help / Email Validation Help / Latest Posts

RE: Email Validation Help

carmanmm — Thu, 16 Apr 2009 01:36:49 GMT

i learned how to do a few things

petrovitch — Mon, 13 Apr 2009 19:26:48 GMT

Validate all input with regular expressions before writing the data to tables.

Professr — Fri, 03 Apr 2009 15:03:04 GMT

Look for email validation REGEXes - they're far more accurate than just checking for an @ sign and a . after it.

quazup — Thu, 02 Apr 2009 11:37:00 GMT

thanks!

Matt.Hill — Fri, 29 Aug 2008 07:15:28 GMT

Hopefully this will help you out a little. This indicates if there is any '_' after the @.

WHERE ((SELECT CHARINDEX('@', emailaddress) +1 ) > (SELECT CHARINDEX('_', emailaddress, (SELECT CHARINDEX('@', emailaddress)))))

krussell47 — Thu, 28 Aug 2008 08:03:03 GMT

Writing an email validation code using select, where, or and like statements. Something like this:

select emailaddress from contact where ((emailaddress = ''

-This looks for entries where email was left blank

I am having trouble making the code to make sure "_" does no appear after "@". If anyone can help me out, thanks.