php发送邮件总是错误[重复]

Question

This question already has an answer here:

• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers

i have an error like this

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in /home/sibisier/public_html/customer/input_customer_issue.php on line 543

and this is the code in line 543

$query_email = "SELECT employee.nip, employee.nama, employee.job_title,
                                    employee.unit_id, employee.business_email, unit.nama_unit
                                    FROM employee
                                    INNER JOIN unit ON employee.unit_id = unit.unit_id
                                    where employee.job_title IN('Team Leader','Assistant Relationship Manager','PROFESSIONAL STAFF')
                                    AND employee.unit_id IN(12)";

                    $resul1 = mysql_query($query_email) or die(mysql_error());{
                        $to = $resul1['business_email'];
                        $subject = 'Notifikasi';

                        $message = "<table>";
                        $message .= "<tr><td>Date</td><td>:</td><td>" . $tanggal_sekarang . "</td></tr>";
                        $message .= "<tr><td>NIP</td><td>:</td><td>" . $nip . "</td></tr>";
                        $message .= "<tr><td>Unit</td><td>:</td><td>" . $resul1['nama_unit'] . "</td></tr>";
                        $message .= "<tr><td>CIF</td><td>:</td><td>" . $cif . "</td></tr>";
                        $message .= "<tr><td>Comment</td><td>:</td><td>" . $comment . "</td></tr>";
                        $message .= "</table>";
                        $headers = "From: [e-mail] 
";
                        $from .= "Reply-To: [e-mail] 
";
                        $from .= "Content-type: text/html 
";
                        mail($to, $subject, $message,$headers, $from);
                        echo "Mail Sent.";

i have no idea, i've been search and always get this error.

please i need help. thanks

</div>

Answer 1

Download PHPMailer package from: http://phpmailer.worxware.com/

and try this code->

<?php
require_once('PHPMailer/class.phpmailer.php');

$query_email = "SELECT employee.nip, employee.nama, employee.job_title,
                                    employee.unit_id, employee.business_email, unit.nama_unit
                                    FROM employee
                                    INNER JOIN unit ON employee.unit_id = unit.unit_id
                                    where employee.job_title IN('Team Leader','Assistant Relationship Manager','PROFESSIONAL STAFF')
                                    AND employee.unit_id IN(12)";

                        $resul1 = mysql_query($query_email) or die(mysql_error());

                        $row=mysql_fetch_array($resul1, MYSQL_ASSOC);
                        if($row)   {
                        $to = $row['business_email'];
                        $htmlbody =  '<table>
                        <tr><td>Date</td><td>:</td><td> '. $tanggal_sekarang .' </td></tr>
                        <tr><td>NIP</td><td>:</td><td> '. $nip .' </td></tr>;
                        <tr><td>Unit</td><td>:</td><td> '. $resul1['nama_unit'] .' </td></tr>;
                        <tr><td>CIF</td><td>:</td><td> '. $cif .' </td></tr>;
                        <tr><td>Comment</td><td>:</td><td> '. $comment .' </td></tr>;
                        </table>';

                        $mail = new PHPMailer();
                        $mail->From      = '[e-mail]';
                        $mail->FromName  = 'yourName';
                        $mail->Subject   = 'Notifikasi';
                        $mail->Body      = $htmlbody;
                        $mail->AddAddress($to);
                        $mail->Send();



    }

?>