include 'getsite.php'; include 'connect.php'; if (isset ($_POST['submit'])){ echo $site_id; $newsleter_email_address = $_POST['newsleter_email_address']; mysql_query("INSERT INTO newsletter (site_id, newsletter_email_address) VALUES('$site_id', '$newsletter_email_address') ") or die(mysql_error()); $main_header = "Newsletter Signup Complete !"; $main_text = "Thank you for signing up for the newsletter, we will ensure you are included in the next mailout."; } else { $resultmain = mysql_query("SELECT * FROM index_text where site_id = $site_id"); while($rowmain = mysql_fetch_array($resultmain)) { ?> $main_header = $rowmain['index_text_header'];?> $main_text = $rowmain['index_text_text']; } } ?>