clear_all_assign(); $db->sql_query("select * from employ order by date desc"); $arr = $db->fetched_array(); $smarty->assign("rows",$arr); $smarty->display("employment.html"); } else { //send to mail $mail = new my_phpmailer; $mail->From = "site@".$_SERVER['SERVER_NAME']; $mail->AddAddress(RESUME_EMAIL); $mail->Subject = "New Ontario Foundry member"; $smarty->clear_all_assign(); $body = $smarty->fetch("resume_file.html"); $mail->Body = $body; $mail->AddAttachment($_FILES['file']['tmp_name'],$_FILES['file']['name']); $mail->IsHTML(true); $mail->Send(); $smarty->clear_all_assign(); $db->sql_query("select * from employ order by date desc"); $arr = $db->fetched_array(); $smarty->assign("rows",$arr); $smarty->display("employment.html"); } ?>