customer recordset used to update multiple orders...need to work out how to send email to all those customers...

Hi. ok well after Ray helping me solve how to update multiple orders using checkboxes...I was wondering how I could also send out order updates to the corresponding emails that belong to the orders I had updated...

The custom code for the record uses an array implode...

<?php

if (isset($_POST["Save"])) {

  mysql_select_db($database_dinkydb, $dinkydb);

  $query_rsOrderDispatched = "UPDATE orders SET OrderProcess = '".$_POST["order-update"]."' WHERE OrderID IN (".implode(", ",$_POST["order-reference"]).")";

  mysql_query($query_rsOrderDispatched, $dinkydb);

}

?>

Now is it a case of still using the Universal Email server behaviour and using the option:RecordSet Loop from the "To Settings" option in the Universal Email and then selecting my recordset for rsOrderDispatched? Or would it require a completely customised email sending function?

Im guessing that may not work as I already have another recordset called rsOrderDispatched has no filters since its used to display a record count (ok just thought that's a sloppy coding method using 2 recordsets the same name)

mysql_select_db($database_dinkydb, $dinkydb);
$query_rsOrderDispatched = "SELECT * FROM orders WHERE OrderProcess = 'Order Dispatched'";
setQueryBuilderSource($query_rsOrderDispatched,$WADA_Sort_1,false);
setQueryBuilderSource($query_rsOrderDispatched,$WADbSearch1,false);
$rsOrderDispatched = mysql_query($query_rsOrderDispatched, $dinkydb) or die(mysql_error());
$row_rsOrderDispatched = mysql_fetch_assoc($rsOrderDispatched);
$totalRows_rsOrderDispatched = mysql_num_rows($rsOrderDispatched);

Chris

The custom update recordset that ray created is an update recordset, it will not return anything, only update the data in the database.

you would need another recordset to return the email addresses for the updated records using the same where clause, and change to a select statement.

then use that recordset in the universal behavior for the to loop

HI, so a recordset like this:

<?php

if (isset($_POST["Save"])) {

  mysql_select_db($database_dinkydb, $dinkydb);

  $query_rsOpenOrdersEmail = "SELECT orders WHERE OrderID IN (".implode(", ",$_POST["order-reference"]).")";

  mysql_query($query_rsOpenOrdersEmail, $dinkydb);

}

?>

Just wondered that this recordset would be triggered as it is using a $_POST So would need to be after my initial update at least. But then again its using isset POST['SAVE'] so that would be the trigger.

Chris

yes, that is correct.

Assuming this error is relating to the second recordset. I have attached a screenshot to show the code and the error

What could be wrong with this recordset syntax?

Chris

SELECT orders

should be:
SELECT * FROM orders

Jason....Lets keep this one between ourselves...cannot believe I missed that lol - When I was looking at the error message I thought it was pointing to near the WHERE clause was since that was part of the error - and that error related to reserved words.

Chris

no worries.