ListMailPRO Email Marketing Software Forums
ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: sanj on March 04, 2007, 03:57:55 am
-
hi,
I'm having a lot of problems wiht automatic submission software.
could anyone give me apiece of code that i can add to my submission form that prevent the form from submitting if fname = lname.
Basically i get a lot entries in my database with the exact same entries for first name and last name and some made up email.
thanks
sanj
-
Hi SanJ,
Check out this post:
http://listmailpro.com/forum/index.php?topic=1203.0
You can do what you want with the following code:
if($fname==$lname) exit;
Regards
-
hi Dean,
My database is now full of rubbish email that have been posted by autobots.
how can i remove them without having to do it manually one by one
thanks
-
If all signups, as you mentioned, have the same fname and lname you could run a custom query with a tool like PhpMyAdmin, commonly accessible from your hosting control panel:
SQL:
DELETE FROM lm_users WHERE fname != '' AND fname = lname;
Regards