assign("submitted_title", $submitted_title ); $smarty->assign("submitted_text", $submitted_text ); $smarty->assign("submitted_keyword", $submitted_keyword ); $smarty->assign("submitted_author", $submitted_author ); $smarty->assign("submitted_author_email", $submitted_author_email ); $smarty->assign("submitted_author_classification", $submitted_author_classification ); $smarty->assign("submitted_author_major", $submitted_author_major ); $smarty->assign("submitted_author_city", $submitted_author_city ); $smarty->assign("submitted_author_telephone", $submitted_author_telephone ); $smarty->assign("submitted_sent", $submitted_sent ); $smarty->assign("submitted_word_count", $submitted_word_count ); $smarty->assign("issue_id", $issue_id ); $query = "INSERT INTO cm_submitted (submitted_title, submitted_text, submitted_keyword, submitted_author, submitted_author_email, submitted_author_classification, submitted_author_major, submitted_author_city, submitted_author_telephone, submitted_sent, submitted_words, issue_id) VALUES ('$submitted_title', '$submitted_text', '$submitted_keyword', '$submitted_author', '$submitted_author_email', '$submitted_author_classification', '$submitted_author_major', '$submitted_author_city', '$submitted_author_telephone', now(), '$submitted_word_count', '$issue_id');"; $stat = run_query($query); if ($stat) { $recipient = site_info('email'); $subject = stripslashes($submitted_title); $message = stripslashes($smarty->fetch("submit-email.tpl")); $header = "From: $submitted_author_email"; $sendit = mail($recipient, $subject, $message, $header); header("Location: $PHP_SELF?msg=submitted"); exit; } else { header("Location: $PHP_SELF?msg=failed"); exit; } } $page_title = "Submit"; // Assign variables $smarty->assign("page_title", $page_title); // Render $smarty->display("submit.tpl");