0 AND user_email like '%aol%' AND user_pdp_evc = 3 ORDER BY `se_users`.`user_id` DESC LIMIT 10 OFFSET 0"; $result= mysql_query($sql) or $em=$em.mysql_error(); while ($row = mysql_fetch_assoc($result)) { $email=trim($row["user_email"]); // an optional sender //$sender = 'host@bateworld.com'; // instantiate the class $SMTP_Validator = new SMTP_validateEmail(); // turn on debugging if you want to view the SMTP transaction $SMTP_Validator->debug = false; // do the validation $results = $SMTP_Validator->validate(array($email), $sender); // view results //echo $email.' is '.($results[$email] ? 'valid' : 'invalid')."\n"; // send email? if ($results[$email]) { $sqlup="UPDATE se_users SET user_pdp_evc = 1 WHERE user_email = '".$email."'"; $rup = mysql_query($sqlup) or $em=$em.mysql_error(); echo "
".$row["user_email"]." ".$row["user_id"]." cool
"; //mail($email, 'Confirm Email', 'Please reply to this email to confirm', 'From:'.$sender."\r\n"); // send email } else { $sqldown="UPDATE se_users SET user_pdp_evc = 0 WHERE user_email = '".$row["user_email"]."'"; $rup = mysql_query($sqldown) or $em=$em.mysql_error(); echo "
".$row["user_email"]." ".$row["user_id"]." not cool
"; var_dump($results); } } exit(); ?>