MySQL: Spam Free (Send/Receive) Emails. HOW?

[deafmickey]

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
-- 
View this message in context: 
http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW--tf2242963.html#a6221195
Sent from the MySQL - General forum at Nabble.com.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL: Spam Free (Send/Receive) Emails. HOW?

[deafmickey]

What is MTA? 

I am not sure if GoDaddy supports Postfix. I will phone Godaddy to find out.

Thanks

Mel


Michael Loftis wrote:
 
 
 
 --On September 9, 2006 12:11:15 AM -0700 deafmickey [EMAIL PROTECTED] 
 wrote:
 

 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.
 
 
 MySQL is not an MTA.  This is the job of your MTA.  Postfix supports 
 lookups via mysql, might want to try there instead.
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 
 
 

-- 
View this message in context: 
http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW--tf2242963.html#a6222963
Sent from the MySQL - General forum at Nabble.com.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]