datassist pages and email

Hi Ray

have set an order update page which am using as a plugin on the orders_detail.php page which updates the order status (shipped, cancelled etc)

When I created the page in DA I set it to email on update. Working fine, but is there any way to modify the content of the email using the update status and product order number in an email similar to the order receipt that gets sent out when someone buys something?

Thanks

Jamie

Yes... you can update the email body and add whatever content you want. You can use an IF statement to check the submitted status and have different email body based on it.

þanks mate. is there a tut anywher on how to go about that?

Just open the email body page and update it like you would any .php page.

Great, have got it all up and running and working except that although the email is going to addresses that have manually been entered in the 'to', 'cc' or 'bcc' fields if the email address is being added from the database it doesnt go through to that address (although it does get sent to any other that have been ,manually entered)

What coul dbe going wrong?

Are you sure the recordset is returning the email address properly? The code looks ok, the only thing I can think is that the Recordset may not be returning a valid email address to begin with.

have tried 3 different emails (all mine) and none of them are receiving...

Like I said... are you sure the recordset is returning the email address properly?

I just took another look... your recordset has:
SELECT OrderID, Order_Status FROM orders

you will need to add the Email Address to the SELECT statement if you want to reference it in the TO line.

sorry, I had attached an older version of the file... the current one just uses * in the SELECT

Try dumping the recordset row to see if it has the email address just before the email sends... and attach a current version of the page if you want me to look at it.