I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails.
I can create a new table for MySQL and write new script for PHP
MySQL:
mysql_query("CREATE TABLE members(
members_id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
email_address VARCHAR(50)")
or die(mysql_error());
mysql_query("CREATE TABLE spam_free(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
members_id (INT),
fake_email VARCHAR(50)")
or die(mysql_error());
?>
PHP:
After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it.
PROBLEM:
I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa.
Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die.
Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail).
I believe its possible but I do not know what code for MySQL.
Thank you so much.
Mel