PhpMailer

<?php
//requiring PHPMailer class
require_once('/var/www/somesite.com/public_html/folder1/classes/phpmailer/class.phpmailer.php');


$mail = new PHPMailer(true); // the true param means it will throw exceptions on errors, which we need to catch



$con = mysql_connect("localhost","root","pass123");
if (!$con)
{
    die('could not connect: '.mysql_error());
} else {
    echo "connected!";
    echo "<br />";
}

mysql_select_db("mydb", $con);
mysql_set_charset('utf8',$con);
$result = mysql_query("SELECT * FROM messages");

while($row = mysql_fetch_array($result))
{
    if (!$row['issent']) {
    $message_id = $row['id'];
    $user_id = $row['user_id'];
    $contact_id = $row['contact_id'];
    $subject = $row['subject'];
    $message = $row['message'];
    $user_email = getemail('users', $user_id, 1);
    $contact_email = getemail('contacts', $contact_id, 6);
    echo "Your message"."<br />"."From: ".$user_email."<br />"."To: ".$contact_email."<br />"."Subject: ".$subject."<br />"."Message: ".$message."<br />";


$mail->IsMail(); // telling the class to use php mail();
$mail->SetFrom('my@email.com', 'The Guy');
$mail->AddReplyTo('my@email.com', 'The Guy');
$mail->Subject    = $subject;
$mail->MsgHTML($message);
$address = $contact_email;
$mail->AddAddress($address, "");


$mail->CharSet = 'utf-8';
if(!$mail->Send()) {
  echo "Mailer Error: " . $mail->ErrorInfo;

} else {

  echo "Message sent!";
  $sql = 'UPDATE messages SET issent=1 WHERE id='.$message_id;
  $result2 = mysql_query($sql);
    }
}
}

function getemail($table, $id, $column){
//getting user or contact email by the id, table and column number
    $sql = 'SELECT * FROM '.$table.' WHERE id='.$id;
    $result_email= mysql_query($sql);
    if (!$result_email) {
        echo 'Could not run query: ' . mysql_error();
        exit;
    }
    $emailrow = mysql_fetch_row($result_email);
    echo "<br />";
    return $emailrow[$column]; //email
}







mysql_close($con);

?>