I'm stuck ... emailing new record

Hi Terry,

So you're getting the system to e-mail you a list of all of the new records, but you're unsure how to store a list of the new records in one large string to e-mail? I think something like this should work:

  //Create the empty message variable
  $message = "";

  //Get the date from yesterday in mysql format
  $yesterdayDate = date('Y-m-d 00:00:00', strtotime('-1 day'));

  //Get all of the records created since yesterday
  $newRecords = mysql_select('cars', "`createdDate` > '".$yesterdayDate."'");


  //Cycle through the new records
  foreach($newRecords as $record){
    //Add each cars name to the message string
    $message .= "{$record['title']}\r\n";
  }


Hopefully the notes I've added to the code will explain what is happening at each step. So by using $message .= I'm adding each new record title to the variable on each loop through.

Cheers!

Greg

Hi Greg,

Thanks for your response and apology for the late reply.

This code works well.

Thanks again.

Terry