How dow add data to table

[nthrusse]

First I need to create a table or add to an existing table - the table needs to contain a date -msg last sent date

 

Then run the following email script for each record if the value of the msg last sent date is greater than >30 days???

after the script is run, it updates the records it emailed to todays date...

 

<?php

include "vsadmin/db_conn_open.php";

$allprods=mysql_query("select pID, pName, pPrice, pDropship, dsID, dsName, dsEmail from products, dropshipper where pDropship = dsID");

while ($yarr=mysql_fetch_assoc($allprods)){

$aname=$yarr["pID"];

$bname=$yarr["pName"];

$cname=$yarr["dsName"];

$dname=$yarr["dsEmail"];

$ename=$yarr["pPrice"];

 

$to = $dname;

$subject = ("Your Ebook: " . $bname);

$body = ("Hello " . $cname .",\n\nYou have the following ebook listed for sale on www.insertwebsite.com (". $bname .").

\nYour Ebook (product) is currently listed at the retail price of $" . $ename .

"\n\nThe following link is provided to you as a marketing tool for your current or future email campaigns.  This link is a direct link to your ebook on the Enlightened Ebooks site.

\n www.www.insertwebsite.com/proddetail.php?prod=". $aname .

"\n\nOnline sales is a safe secure way to increase your ebook sales.  Simply provide the link in all your correspondences and you sales will increase.  You are your own best promoter.");

$headers = "From: [email protected]\r\n" .

  "X-Mailer: php";

if (mail($to, $subject, $body, $headers)) {

  echo("<p><b>Message sent to.</b></P>". $cname . "  for the following ebook  " . $bname );

  } else {

  echo("<p>Message delivery failed...</p>");

  }}

?>

[BlueSkyIS]

good idea!