<?php 
include_once("session.php");
include_once("settings.php");
include_once("functions.php");

$msg = "";
if(isset($_POST["Submit"]) == "Submit")
{
  $offer_settings = $_POST['offer_settings'];
  $sql = mysql_query("UPDATE `tblUsers` SET `offer_settings` = '".$offer_settings."' WHERE `id` = '2' ");   
  
  $msg = "Offer settings updated successfully.";
}

$sql_query = mysql_query("SELECT offer_settings FROM `tblUsers` WHERE `id` = '2' ");
$offer_setting = mysql_fetch_assoc($sql_query);

?> 
<LINK href="mel.css" type=text/css 
rel=stylesheet><LINK href="sdmenu.css" 
type=text/css rel=stylesheet>
<script language="JavaScript">
function  validate()
{
	if ((document.offer_settings_form.offer_settings[0].checked == false) && (document.offer_settings_form.offer_settings[1].checked == false))
	{
		alert("Please choose offer setting.")
		return false;
	}
	
	return true;
}

</script>

<table width="94%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td><form id="offer_settings_form" name="offer_settings_form" action="" method="post" onsubmit="return validate();">
        <fieldset>
        <legend>OFFER SETTINGS FORM</legend>
        <table width="97%" border="0" cellspacing="2" cellpadding="0">
		
		 <?php 
		 if($msg !="" && isset($msg)) { 
		 ?>
		 <tr align="center"> 
            <td height="26" colspan="2"><span style="color:#009900;"><?php echo $msg;?></span></td>
          </tr>
		 <?php } ?> 
		  
          <tr> 
            <td width="30%" height="26" class="general">Offer Setting :</td>
            <td width="70%" height="26" > <input name="offer_settings" type="radio" value="yes" AUTOCOMPLETE="OFF"  size="22" <?php if($offer_setting['offer_settings']=="yes") { echo "checked=checked"; } ?> /> Yes &nbsp;&nbsp; 
			<input name="offer_settings" type="radio" AUTOCOMPLETE="OFF" value="no"  size="22" <?php if($offer_setting['offer_settings']=="no") { echo "checked=checked"; } ?> /> No  </td>
          </tr>
          
          <tr align="center"> 
            <td height="26" colspan="2"><label for="label"> 
              <input type="submit" name="Submit" value="Submit" class="button" />
              &nbsp;&nbsp;&nbsp;&nbsp; 
              <input type="reset" name="Submit" value="Reset" class="button" />
              </label></td>
          </tr>
        </table>
        </fieldset>
      </form></td>
  </tr>
</table>