email log addin to the db

Hey Ray

Couple of questions re universal email. On the atatched page (direct-access.php) why would the submit upload 2 entries into the database? Am assuming its because there are 2 $Email->addTo but how can I stop that from happening and retain the 2 emails?

2nd question is how do I combine these to inputs to both be added to one column 'Name'?

$Email->onSend->Query->bindColumn("FirstName", "s", "".((isset($_POST["First_Name"]))?$_POST["First_Name"]:""));
    $Email->onSend->Query->bindColumn("LastName", "s", "".((isset($_POST["Last_Name"]))?$_POST["Last_Name"]:""));

Thanks

Jamie

You could copy your email server behavior so it sends to the two recipients separately and only use logging for one or the other.

You could combine the fields like:

$Email->onSend->Query->bindColumn("FullName", "s", "".((isset($_POST["First_Name"]))?$_POST["First_Name"]:"") ." " . ((isset($_POST["Last_Name"]))?$_POST["Last_Name"]:""));

    $Email->onSend->Query->bindColumn("LastName", "s", "".);

Many thanks Ray

How would I create a cron and script to remove any records in the email_log table that are older than 90 days?

Create a web page that does it, then add a cron to run that web page daily.

So should this remove any record in table email_log where EmailDate is older than 90 days?

<?php require_once('../Connections/DBConnection.php'); ?>
<?php require_once('../webassist/mysqli/rsobj.php'); ?>
<?php
$LogPurge = new WA_MySQLi_RS("LogPurge",$DBConnection,0);
$LogPurge->setQuery("DELETE FROM email_log WHERE EmailDate < DATEADD(day, -90, GETDATE())");
$LogPurge->execute();
?>

Yes, that looks like it would do the trick.

thanks Ray