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]
