leemo

As stated in the first post I am receiving all the information correctly but in separate Emails. My results are between 1-20 records, which of course is 1-20 Emails. Requinix I have changed the subject variable to make more sense if receving one Email. I need to loop the information in the $msg.= sections into one email. I have added: while ($values = mysqli_fetch_array($result)) and put the area I need looped in curly brackets, not sure if that is the correct way to do it. But, as the code stands below I am not receiving any Emails at all. $email="[email protected]"; $from="[email protected]"; $msg=""; $subject="Registers Info for: ".$values["classname"]." ".$values["attendance_date"].""; while ($values = mysqli_fetch_array($result)) { $msg.= "Student: ".$values["first_name"]." ".$values["last_name"]."\r\n"; $msg.= "Absent or Present: ".$values["attendance_status"]."\r\n"; $msg.= "Class: ".$values["classname"]."\r\n"; $msg.= "Class Date: ".$values["attendance_date"]."\r\n"; $msg.= "Amount Received: ".$values["cash_received"]."\r\n"; $msg.= "Paid For: ".$values["cash_whatfor"]."\r\n"; } $ret=runner_mail(array('to' => $email, 'subject' => $subject, 'body' => $msg, 'from'=>$from)); SELECT attendance.attendance_id, attendance.student_id, attendance.class_id, attendance.attendance_status, attendance.attendance_date, attendance.cash_received, attendance.cash_whatfor, students.last_name, students.first_name, classes.classname FROM attendance INNER JOIN classes ON attendance.class_id = classes.class_id INNER JOIN students ON attendance.student_id = students.student_id ORDER BY students.last_name

No Emails were sent using the previous block of code. The code is an After Record Updated event with PHP Runner software

{ $email="[email protected]"; $from="[email protected]"; $msg=""; $subject="Registers Info for: ".$values["classname"]." ".$values["attendance_date"].""; while ($msg = mysqli_fetch_array($result)) { $msg.= "Student: ".$values["first_name"]." ".$values["last_name"]."\r\n"; $msg.= "Absent or Present: ".$values["attendance_status"]."\r\n"; $msg.= "Class: ".$values["classname"]."\r\n"; $msg.= "Class Date: ".$values["attendance_date"]."\r\n"; $msg.= "Amount Received: ".$values["cash_received"]."\r\n"; $msg.= "Paid For: ".$values["cash_whatfor"]."\r\n"; } $ret=runner_mail(array('to' => $email, 'subject' => $subject, 'body' => $msg, 'from'=>$from)); } This isn't correct, but I'm doing my best!

Thanks for your replies. I'm trying so hard as a noob to work my way around things on my own and it's a great feeling when things work. It took me 2 days to get as far as this 🙂 I've tried the magic curly brackets before and after the actual message section, do I also need to add something similar to this: while ($msg = mysqli_fetch_array($result)) - before the message section and I'm guessing I need something at the end also?

The code below currently sends a separate Email with data from each row of a table when a Save All button is pressed. So, if I have 4 rows of data, 4 Email will be sent. I would prefer to receive one Email with 4 sections of data. Any help greatly appreciated. $email="[email protected]"; $from="[email protected]"; $msg=""; $subject="Registers Info for: ".$values["first_name"]." ".$values["last_name"].""; $msg.= "Student: ".$values["first_name"]." ".$values["last_name"]."\r\n"; $msg.= "Absent or Present: ".$values["attendance_status"]."\r\n"; $msg.= "Class: ".$values["classname"]."\r\n"; $msg.= "Class Date: ".$values["attendance_date"]."\r\n"; $msg.= "Amount Received: ".$values["cash_received"]."\r\n"; $msg.= "Paid For: ".$values["cash_whatfor"]."\r\n"; $ret=runner_mail(array('to' => $email, 'subject' => $subject, 'body' => $msg, 'from'=>$from)); if(!$ret["Sent"]) echo $ret["message"];