email - PHP PDO send e-mail code only sends if text-only - need to send HTML -
i'm making code (1) moves records 1 table (in same database), (2) sends contents of table 1 pre-determined e-mail, , (3) delete contents of table 1 - simulating "add cart" feature. my problem code below successful in sending e-mail if $headers not sent on mail(). however, need send table contents html or @ least allow different records. if chance e-mail isn't sent, delete part of code isn't executed either. doing wrong? thanks in advance! modified code (that works if don't send $headers ) <?php include '../config/database.php'; date_default_timezone_set('cet'); $date = date('y-m-d h:i:s'); $query = "insert claims_archive (t20pctid, total_amount, user_id, sent) select t20pctid, total_amount, user_id, @date cart t20pctid '%sony%'"; $stmt = $con->prepare($query); if ($stmt->execute()) { $query = "select t.t20pctid, t.main_artist, t.track_title, t.original_album,...