raj86

Hello seanlim you wrote: Your other option will to populate and select the option through PHP. 1. Dynamically-created SELECT loses its previously-selected value You will have to use Javascript to dynamically-select the option you want, after changeList() is called in the onload event. 2. Designation field not inserted into DB Please post your PHP code which handles the form submission. i am not able to write javascript to make it work........can you please help me to wrie it so that the above problems do not come. thank you

is it possible to convert javascript values(jvascript pasted above) into php values so that we can send that value into database...

hello friends... In my form i am using 32 fields.....1) name 2)dob etc..... now the problem is, suppose i have entered 12345 insted of my name so at that time it will show error message : Please enter a valid name after this my selected value of designation will be reset...........so after every validation error i have to select the designation value.... I want the output like when i select any designation : TA from employee type 2 , this value should not reset every time and the same value TA should go in the database i dont know whether i have to change in the javascript or in php code I am putting complete code of the form.....3rd is the dynamice drop down and its value i am getting in the 9th field Designation <?php //f2003862 //otw824 session_start(); $_POST['psrn']=0; $_POST['desig']=""; $error_msg=" "; $_SESSION['psrn_no']=$_POST['psrn']; require($_SERVER["DOCUMENT_ROOT"]."/config/config.php"); $connection = mysql_connect($host, $user, $password) or die("error connecting"); mysql_select_db('bits_sap') or die("cannot select database"); $str="select MAX(PSRN) from paymajor"; $result=mysql_query($str) or die(mysql_error()); while($row=mysql_fetch_assoc($result)) { $psrn=$row['MAX(PSRN)']+1; } ?> <script language="javascript"> function highlight(field) { field.focus(); field.select(); } </script> <script language="javascript"> function checkName(str) { var name = new RegExp("^[a-zA-Z .]+$"); if (!str.match(name) && (name!="")) alert('Invalid characters in Name.'); } </script> <script language="javascript"> function checkNumber(str) { var number = new RegExp("^[0-9]+$"); if (!str.match(number) && (number!="")) alert('Invalid Numbers.'); } </script> <script language="javascript"> function addOption(selectList,optionText,optionValue) { var newOption = document.createElement('OPTION'); newOption.text = optionText; newOption.value = optionValue; selectList.options.add(newOption); } function changeList(list1,list2) { list2.length = 0; if(list1.options[list1.selectedIndex].value == 2) { addOption(list2,"ACTD","ACTD"); addOption(list2,"ALEC","ALEC"); addOption(list2,"ASOP","ASOP"); addOption(list2,"ASTP","ASTP"); addOption(list2,"DIRO","DIRO"); addOption(list2,"DLIB","DLIB");addOption(list2,"LECT","LECT"); addOption(list2,"PFAT","PFAT"); addOption(list2,"PROF","PROF");addOption(list2,"TA","TA"); addOption(list2,"VFAC","VFAC"); addOption(list2,"VPRF","VPRF"); } else if(list1.options[list1.selectedIndex].value == 3) { addOption(list2,"ACCO","ACCO"); addOption(list2,"APRG","APRG"); addOption(list2,"ASTR","ASTR"); addOption(list2,"COCH","COCH"); addOption(list2,"CSHR","CSHR"); addOption(list2,"CTOR","CTOR"); addOption(list2,"DRVR","DRVR"); addOption(list2,"DUDT","DUDT"); addOption(list2,"ELER","ELER"); addOption(list2,"FINO","FINO"); addOption(list2,"HSPT","HSPT"); addOption(list2,"JAAT","JAAT"); addOption(list2,"JOAT","JOAT"); addOption(list2,"JTEC","JTEC"); addOption(list2,"LABT","LABT"); addOption(list2,"LBST","LBST"); addOption(list2,"LIST","LIST");addOption(list2,"MEDA","MEDA"); addOption(list2,"MO","MO"); addOption(list2,"OFST","OFST"); addOption(list2,"PA","PA");addOption(list2,"PAST","PAST");addOption(list2,"PRGR","PRGR"); addOption(list2,"SCOP","SCOP"); addOption(list2,"SLAT","SLAT"); addOption(list2,"SMDA","SMDA"); addOption(list2,"SMDO","SMDO"); addOption(list2,"SNRS","SNRS"); addOption(list2,"STCH","STCH");addOption(list2,"SUPV","SUPV"); addOption(list2,"WSPT","WSPT"); } else if(list1.options[list1.selectedIndex].value == 4) { addOption(list2,"ATDT","ATDT");addOption(list2,"CHWK","CHWK"); addOption(list2,"LIDT","LIDT"); addOption(list2,"NRSE","NRSE"); addOption(list2,"OAST","OAST"); } } </script> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <body bgcolor="#cccccc" style="color:#000099" onload="changeList(document.forms.form2.emptyp,document.forms.form2.desig)" > <hr style="color:#000099"> <h2 align="center" class="style1">PAY ENTRY</h2> <hr style="color:#000099"> <title>Pay Entry</title> <style type="text/css"> <!-- .style1 { font-family: Arial, Helvetica, sans-serif; background-color: #CCCCCC; color: #000099; } --> <style> .error{ color:#F00; } /* Displays Star in Red color */ .default_star{ color: red; font-weight: bold; } </style> <script language="javascript" type="text/javascript" src="scripts/datetimepicker_css.js"></script> </head> <form action="" id="form2" method="post" name="form1" class="style1"> <td width="50%" valign="top"> <font color="##FF0000" >*</font> <label>indicates mandatory field</label> <table border="0" width="100%" cellpadding="10"> <tr> <td width="50%" colspan="2" valign="top" > <?php echo "1. PSRN: ",$psrn; ?> <br><br> <label>2. BSRN</label> <input type="text" name="bsr" size="3" maxlength="3" onclick='highlight(this);' value="<?php if (isset($_POST['submit'])) echo $_POST['bsr'];?>"> <br><br> <label>3. Employee Type</label> <font color="##FF0000" >*</font> <select name="emptyp" onChange="changeList(document.forms.form2.emptyp,document.forms.form2.desig)"> <option value="2" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '2') { echo "selected='selected'"; }?> >2 (Teaching faculty)</option> <option value="3" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '3') { echo "selected='selected'"; }?> >3 (Supporting staff)</option> <option value="4" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '4') { echo "selected='selected'"; }?> >4 (Helping staff)</option> </select> <br> <br> <label>4. Name</label> <font color="##FF0000" >*</font> <input type="text" name="name" size="30" maxlength="30" onKeyUp="checkName(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['name']; ?>"><br><br> <label>5. Sex</label> <select name="sx"> <option value='M' <?php if (isset($_POST['sx']) && $_POST['sx'] == 'M') { echo "selected='selected'"; }?> >Male</option> <option value='F' <?php if (isset($_POST['sx']) && $_POST['sx'] == 'F') { echo "selected='selected'"; }?> >Female</option> </select> <br><br> <!-- <?php if (trim($_POST["sx"]) == "M") echo " selected ";?> --> <label>6. Date of Birth</label> <input id="dob" name="dob" size="10" value="<?php if (isset($_POST['submit'])) echo $_POST['dob'];?> "><a href="javascript:NewCssCal('dob','yyyyMMdd')"><img src="scripts/cal.gif" width="16" height="16" border="0" alt="Pick a date"></a><br> <br> <label>7. Date of Joining</label> <input id="doj" name="doj" size="10" value="<?php if (isset($_POST['submit'])) echo $_POST['doj'];?> "><a href="javascript:NewCssCal('doj','yyyyMMdd')"><img src="scripts/cal.gif" width="16" height="16" border="0" alt="Pick a date"></a><br> <br> <label>8. Date of Term Expiry</label> <input id="dot" name="dot" size="10" value="<?php if (isset($_POST['submit'])) echo $_POST['dot'];?> "><a href="javascript:NewCssCal('dot','yyyyMMdd')"><img src="scripts/cal.gif" width="16" height="16" border="0" alt="Pick a date"></a><br> <br> <label >9. Designation</label> <select name="desig" id="desig" value="<?php if (isset($_POST['submit'])) echo selected ?>" > </select> <br><br> <label>10. Family Pens</label> <select name="fp_mem_yn"> <option value='T' <?php if (isset($_POST['fp_mem_yn']) && $_POST['fp_mem_yn'] == 'T') { echo "selected='selected'"; }?> >Yes</option> <option value='F' <?php if (isset($_POST['fp_mem_yn']) && $_POST['fp_mem_yn'] == 'F') { echo "selected='selected'"; }?> >No</option> </select><br><br> <label>11. Internal Division Code</label> <select name="intdiv"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option><option value="4">4</option> <option value="5">5</option><option value="6">6</option> <option value="7">7</option> <option value="8">8</option><option value="9">9</option> <option value="10">10</option><option value="11">11</option> <option value="12">12</option> <option value="13">13</option><option value="14">14</option> <option value="15">15</option><option value="16">16</option> <option value="17">17</option> <option value="18">18</option><option value="19">19</option> <option value="20">20</option><option value="21">21</option> <option value="22">22</option> <option value="23">23</option> </select><br><br> <label>12. Budget Division Code</label> <select name="buddiv"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option><option value="4">4</option> <option value="5">5</option><option value="6">6</option> <option value="7">7</option> <option value="8">8</option><option value="9">9</option> <option value="10">10</option><option value="11">11</option> <option value="12">12</option> <option value="13">13</option><option value="14">14</option> <option value="15">15</option><option value="16">16</option> <option value="17">17</option> <option value="18">18</option><option value="19">19</option> <option value="20">20</option><option value="21">21</option> <option value="22">22</option> <option value="23">23</option> </select><br><br> <label>13. Grade Code</label> <select name="grdcode"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option><option value="4">4</option> <option value="5">5</option><option value="6">6</option> <option value="7">7</option> <option value="8">8</option><option value="9">9</option> <option value="10">10</option><option value="11">11</option> <option value="12">12</option> <option value="13">13</option><option value="14">14</option> <option value="15">15</option><option value="16">16</option> <option value="17">17</option> <option value="18">18</option><option value="19">19</option> </select><br><br> <label>14. Basic Pay</label> <font color="##FF0000" >*</font> <input type="text" name="basic" size="6" maxlength="6" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['basic'];?>"> </select> <br> <br> <label>15. Allowance without PF</label> <input type="text" name="alwopf" size="6" maxlength="6" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['alwopf'];?>"> </select> <br> <br> </td> <td width="50%" valign="top"> <label>16. Allowance with PF</label> <input type="text" name="alwipf" size="6" maxlength="6" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['alwipf'];?>"> </select> <br> <br> <label>17. Bank code</label> <select name="bankcode"> <option value="SBI">SBI</option> </select><br><br> <label>18. Bank A/C No.</label> <input type="text" name="bankac" size="11" maxlength="11" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['bankac'];?>"> </select> <br> <br> <label>19. Draft Code</label> <font color="##FF0000" >*</font> <input type="text" name="draftcode" size="2" maxlength="2" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['draftcode'];?>"> </select> <br> <br> <label>20. Fixed Pay Code</label> <select name="fixpcode"> <option value="0" <?php if (isset($_POST['fixpcode']) && $_POST['fixpcode'] == '0') { echo "selected='selected'"; }?> >0 (not fixed)</option> <option value="1" <?php if (isset($_POST['fixpcode']) && $_POST['fixpcode'] == '1') { echo "selected='selected'"; }?>>1 (fixed)</option> </select><br><br> <label>21. Increment(Month)</label> <select name="incmon" value="<?php if (isset($_POST['submit'])) echo $_POST['incmon'];?>"> <option value="0">0 (no increment)</option> <option value="1" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '1') { echo "selected='selected'"; }?> >1 </option> <option value="2" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '2') { echo "selected='selected'"; }?> >2 </option> <option value="3" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '3') { echo "selected='selected'"; }?> >3 </option> <option value="4" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '4') { echo "selected='selected'"; }?> >4 </option> <option value="5" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '5') { echo "selected='selected'"; }?> >5 </option> <option value="6" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '6') { echo "selected='selected'"; }?> >6 </option> <option value="7" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '7') { echo "selected='selected'"; }?> >7 </option> <option value="8" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '8') { echo "selected='selected'"; }?> >8 </option> <option value="9" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '9') { echo "selected='selected'"; }?> >9 </option> <option value="10" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '10') { echo "selected='selected'"; }?>>10</option> <option value="11" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '11') { echo "selected='selected'"; }?> >11</option> <option value="12" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '12') { echo "selected='selected'"; }?> >12</option> </select><br><br> <label>22. Increment Year</label> <input type="text" name="incyr" size="4" maxlength="4" value="<?php if (isset($_POST['submit'])) echo $_POST['incyr'];?>"> </select> (yyyy) <br> <br> <label>23. PF OWN</label> <input type="text" name="pfown" value="12" size="2" maxlength="2" onBlur="checkNumber(this.value)" onclick='highlight(this);' > </select> <br> <br> <label>24. PF EMPLOYER</label> <input type="text" name="pfemp" value="12" size="2" maxlength="2" onBlur="checkNumber(this.value)" onclick='highlight(this);' > </select> <br> <br> <label>25. House No.</label> <input type="text" name="houseno" size="7" maxlength="7" value="<?php if (isset($_POST['submit'])) echo $_POST['houseno'];?>"> </select> <br> <br> <label>26. House Rent</label> <input type="text" name="house_rent" size="4" maxlength="4" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['house_rent'];?>"> </select> <br> <br> <label>27. TCC</label> <input type="text" name="tcc" size="4" maxlength="4" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['tcc'];?>"> </select> <br> <br> <label>28. Meter Rent</label> <select name="meter_rent"> <option value="0">0 </option> <option value="1">1 </option> <option value="2">2 </option> <option value="3">3 </option> <option value="4">4 </option> <option value="5">5 </option> <option value="6">6 </option> <option value="7">7 </option> <option value="8">8 </option> <option value="9">9 </option> <option value="10">10 </option> <option value="11">11 </option> <option value="12">12</option> </select> <br> <br> <label>29. STAFF ASSOCIATION</label> <select name="stf_assoc"> <option value="0" <?php if (isset($_POST['stf_assoc']) && $_POST['stf_assoc'] == '0') { echo "selected='selected'"; }?> >0 </option> <option value="3" <?php if (isset($_POST['stf_assoc']) && $_POST['stf_assoc'] == '3') { echo "selected='selected'"; }?> >3 </option> </select> <br> <br> <label>30. BITS COOP</label> <select name="bits_coop"> <option value="0" <?php if (isset($_POST['bits_coop']) && $_POST['bits_coop'] == '0') { echo "selected='selected'"; }?> >0 </option> <option value="1" <?php if (isset($_POST['bits_coop']) && $_POST['bits_coop'] == '1') { echo "selected='selected'"; }?> >1 </option> </select> <br> <br> <label>31. Vacation Days</label> <select name="vacday"> <option value="0" <?php if (isset($_POST['vacday']) && $_POST['vacday'] == '0') { echo "selected='selected'"; }?> >0 </option> <option value="30" <?php if (isset($_POST['vacday']) && $_POST['vacday'] == '30') { echo "selected='selected'"; }?> >30 </option> <option value="60" <?php if (isset($_POST['vacday']) && $_POST['vacday'] == '60') { echo "selected='selected'"; }?>>60 </option> </select> <br> <br> <label>32. Name of Father/Husband</label> <font color="##FF0000" >*</font> <input type="text" name="fathhusb" size="25" maxlength="25" onKeyUp="checkName(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['fathhusb'];?>"> </select> <br> <br> </td> </tr> </table> <br><br> <center> <label><b>Are the entries correct?</b></label> <input type="submit" name="submit" value="Submit" style="width:50px" onclick="ConfirmDelete;" /> <input type="button" name="submit2" value="Main Menu" onclick='window.location="http://localhost/bitssap/index.php"' /> </center> </form> </body> </html> <?php if( isset($_POST['submit'])) { $bsr=0; $flg=0; $emptyp=0;$intdiv=0;$buddiv=0;$grdcode=0;$basic=0;$tempda=0;$intrel=0;$alwopf=0;$alwipf=0;$draftcode=0;$fixpcode=0;$incmon=0;$incyr=0;$pfown=0;$pfemp=0;$vacday=0;$intgroup=0;$tcch=0;$budgroup=0;$house=0;$houserent=0;$meterrent=0;$stfassoc=0;$bitscoop=0;$nam='fg';$fathhusb='ui';$desig='abc';$admdesig='jio';$grdcode=0; $bankac='r';$bankcode='78';$sx='M';$fp_mem_yn='T'; $bsr=($_POST['bsr']); if(preg_match('/[^0-9]/', $bsr)) { die ("Error: BSRN should be a numeric value."); } $emptyp=($_POST['emptyp']); if (isset($_POST['emptyp']) && ($_POST['emptyp'] == 'Select')) { die("Please select employee type."); } $name=($_POST['name']); if(trim($_POST['name']) == "") { die ('<font color="##FF0000">Please enter a valid name.</font>'); } else if(preg_match('/[^A-Za-z .]/', $_POST['name'])) { die ("Error: Name should be a character value."); } $sx=($_POST['sx']); $current_date=date('Y-m-d'); $dob = $_POST['dob']; function birthday($dob){ list($year,$month,$day)=explode("-",$dob); $year_diff= date("Y") - $year; $month_diff= date("m") - $month; $day_diff= date("d") - $day; if($month_diff < 0) { $year_diff--; }elseif(($month_diff==0) && ($day_diff <0)) $year_diff--; return $year_diff; } $age=birthday($dob); if(trim($_POST['dob']) == "") { die ('<font color="##FF0000">Please select the date of birth</font>'); } else if($dob >= $current_date) { die ('<font color="##FF0000">Birth date is greater than or equal to Current date</font>'); } else if($age < 18) { die('<font color="##FF0000">Sorry You are under 18</font>'); } else $date_birth = $_POST['dob']; //echo "Date of birth: $dob"; //echo "Current date: $current_date"; $date_join = $_POST['doj']; if(trim($_POST['doj']) == "") { die ('<font color="##FF0000">Please select the joining date</font>'); } else if($current_date < $date_join) { die ('<font color="##FF0000">Joining date can not be greater current date</font>'); } else if($date_join <= $date_birth) { die ('<font color="##FF0000">Birth date can not be greater than or equal to joining date.</font>'); } $date_term = $_POST['dot']; if(trim($_POST['dot']) == "") { die ('<font color="##FF0000">Please select the termination date</font>'); } else if($date_term < $current_date ) { die ('<font color="##FF0000">Enter a valid termination date, Termination date should be later than current date</font>'); } $desig=($_POST['desig']); echo"sekfjkejsfseflsekf: $desig"; $fp_mem_yn=($_POST['fp_mem_yn']); $intdiv=($_POST['intdiv']); $buddiv=($_POST['buddiv']); $grdcode=($_POST['grdcode']); $basic=($_POST['basic']); if(trim($_POST['basic']) == "") { die ("Please enter basic pay."); } else if(preg_match('/[^0-9]/', $basic)) { die ("Error: Basic pay should be a numeric value."); } else if(($basic<2300 | $basic>50000) ) { die ("ERROR: Invalid Basic Pay.Enter between 2300 and 50000"); } $alwopf=($_POST['alwopf']); if(preg_match('/[^0-9]/', $alwopf)) { die ("Allowance without PF should be a numeric value."); } $alwipf=($_POST['alwipf']); if(preg_match('/[^0-9]/', $alwipf)) { die ("Allowance with PF should be a numeric value."); } $bankcode=($_POST['bankcode']); $bankac=($_POST['bankac']); if(preg_match('/[^0-9]/', $bankac)) { die ("Please enter only integer value for account number."); } else if(is_numeric($bankac)) { if(strlen($bankac)!=11) { die ("ERROR: Enter the 11 digit integer value for bank account number."); } } $draftcode=($_POST['draftcode']); if(strlen($bankac)==0 ) { $draftcode=($_POST['draftcode']); if(trim($_POST['draftcode']) == "") { die ("Please enter valid draft code."); } else if(preg_match('/[^0-9]/', $draftcode)) { die ("Error: Draft code should be a numeric value."); } else if(($draftcode<1 | $draftcode>99)) { die ("ERROR: Invalid Draft code.Enter between 1 and 99"); } } $fixpcode=($_POST['fixpcode']); if($fixpcode==0) //&& $basic>=2300 && $basic<=15000 { $query = "SELECT DDA FROM newdatab WHERE newdatab.RANGE1<=$basic AND newdatab.RANGE2>=$basic"; $result1= mysql_query($query, $connection) or die ("Error in query: $query"); $dda=mysql_result($result1,0,"DDA"); if ($result1) { $tempda=$dda; } else die("ERROR:No DA exists for this Basic Pay"); } $incmon=($_POST['incmon']); $incyr=($_POST['incyr']); if($incmon==0 && $incyr!=0){ die("Please select the increment month."); } else if($incmon!=0){ $year=date("Y"); $month=date("m"); if(trim($_POST['incyr']) == "") { die ('Please enter increment year value.'); } if(preg_match('/[^0-9]/', $incyr)) { die ("Please enter only integer value for increment year."); } if(is_numeric($incyr)) //PHP function to check the date entered. { if(strlen($incyr)!=4) { die ('ERROR: Enter a valid 4 digit increment year.'); } } if(($incyr <= $year) && ($incmon < $month)) { die ("Error: Increment year can not be less than current year."); } } $pfown=($_POST['pfown']); if($pfown>0) { $pfemp=12; } $houseno=($_POST['houseno']); $houserent=($_POST['house_rent']); if(preg_match('/[^0-9]/', $houserent)) { die ("House rent should be a numeric value."); } $tcch=($_POST['tcc']); if(preg_match('/[^0-9]/', $tcch)) { die ("TCC should be a numeric value."); } $meterrent=($_POST['meter_rent']); $stfassoc=($_POST['stf_assoc']); $bitscoop=($_POST['bits_coop']); $vacday=($_POST['vacday']); $fathhusb=($_POST['fathhusb']); if(trim($_POST['fathhusb']) == "") { die ("Please enter a valid Father/Husband name."); } else if(preg_match('/[^A-Za-z .]/', $_POST['fathhusb'])) { die ("Error: Father/Husband name should be a character value."); } $query = "INSERT INTO `paymajor` (`PSRN`, `BSRN`, `FLAG`, `EMP_TYPE`, `NAME`,`GENDER`, `DATE_BIRTH`, `DATE_JOIN`, `DATE_TERM`, `DESIG`, `ADM_DESIG`, `INT_DIV`, `INT_GROUP`, `BUD_DIV`, `BUD_GROUP`, `GRADE_CODE`, `BASIC_PAY`, `DA`, `INT_RELIEF`, `AL_WO_PF`, `AL_W_PF`, `BANK_CODE`, `BANK_AC`,`DRAFT_CODE`, `FIX_P_CODE`, `INC_MONTH`, `INC_YEAR`, `PF_OWN`, `PF_EMP`, `HOUSE_NO`, `HOUSE_RENT`, `TCC`, `METER_RENT`, `STF_ASSOC`, `BITS_COOP`, `VAC_DAYS`, `FATH_HUSB`) VALUES ('$psrn','$bsr','$flg','$emptyp','$name','$sx','$date_birth','$date_join','$date_term','$desig','$admdesig','$intdiv','$intgroup','$buddiv','$budgroup','$grdcode','$basic','$tempda','$intrel','$alwopf','$alwipf','$bankcode','$bankac','$draftcode','$fixpcode','$incmon','$incyr','$pfown','$pfemp','$houseno','$houserent','$tcch','$meterrent','$stfassoc','$bitscoop','$vacday','$fathhusb')"; $result = mysql_query($query) or die ("Error in query: $query"); if($result) { header ('Location: http://localhost/bitssap/success.php?psrn=' .$psrn); //print 'alert("Data entered successfully. The PSRN generated is" )'; } else { echo "Error. Please enter again.";} $query1 = "INSERT INTO `payminor` (`PSRN`) VALUES ('$psrn')"; $query2 = "INSERT INTO `paysumer` (`PSRN`) VALUES ('$psrn')"; $result = mysql_query($query1) or die ("Error in query: $query1. " . mysql_error()); $result = mysql_query($query2) or die ("Error in query: $query2. " . mysql_error()); } ?>

please help me to solve this problem.......

thanks its working

this is the form tag in my php for <form action="" id="form2" method="post" name="form1" class="style1">

hello friends.... i am having a working javascript....when i am selecting any designation and refresh/validation problem the form is resetting the designation value and the designation value is not going into the database.....please look at the below code and suggest me how to make it work... function changeList(list1,list2) { list2.length = 0; if(list1.options[list1.selectedIndex].value == 2) { addOption(list2,"ACTD","ACTD"); addOption(list2,"ALEC","ALEC"); addOption(list2,"ASOP","ASOP"); addOption(list2,"ASTP","ASTP"); addOption(list2,"DIRO","DIRO"); addOption(list2,"DLIB","DLIB");addOption(list2,"LECT","LECT"); addOption(list2,"PFAT","PFAT"); addOption(list2,"PROF","PROF");addOption(list2,"TA","TA"); addOption(list2,"VFAC","VFAC"); addOption(list2,"VPRF","VPRF"); } else if(list1.options[list1.selectedIndex].value == 3) { addOption(list2,"ACCO","ACCO"); addOption(list2,"APRG","APRG"); addOption(list2,"ASTR","ASTR"); addOption(list2,"COCH","COCH"); addOption(list2,"CSHR","CSHR"); addOption(list2,"CTOR","CTOR"); addOption(list2,"DRVR","DRVR"); addOption(list2,"DUDT","DUDT"); addOption(list2,"ELER","ELER"); addOption(list2,"FINO","FINO"); addOption(list2,"HSPT","HSPT"); addOption(list2,"JAAT","JAAT"); addOption(list2,"JOAT","JOAT"); addOption(list2,"JTEC","JTEC"); addOption(list2,"LABT","LABT"); addOption(list2,"LBST","LBST"); addOption(list2,"LIST","LIST");addOption(list2,"MEDA","MEDA"); addOption(list2,"MO","MO"); addOption(list2,"OFST","OFST"); addOption(list2,"PA","PA");addOption(list2,"PAST","PAST");addOption(list2,"PRGR","PRGR"); addOption(list2,"SCOP","SCOP"); addOption(list2,"SLAT","SLAT"); addOption(list2,"SMDA","SMDA"); addOption(list2,"SMDO","SMDO"); addOption(list2,"SNRS","SNRS"); addOption(list2,"STCH","STCH");addOption(list2,"SUPV","SUPV"); addOption(list2,"WSPT","WSPT"); } else if(list1.options[list1.selectedIndex].value == 4) { addOption(list2,"ATDT","ATDT");addOption(list2,"CHWK","CHWK"); addOption(list2,"LIDT","LIDT"); addOption(list2,"NRSE","NRSE"); addOption(list2,"OAST","OAST"); } } </script> <body bgcolor="#cccccc" style="color:#000099" onload="changeList(document.forms.form2.emptyp,document.forms.form2.desig)" > <label>3. Employee Type</label> <font color="##FF0000" >*</font> <select name="emptyp" onChange="changeList(document.forms.form2.emptyp,document.forms.form2.desig)"> <option value="2" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '2') { echo "selected='selected'"; }?> >2 (Teaching faculty)</option> <option value="3" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '3') { echo "selected='selected'"; }?> >3 (Supporting staff)</option> <option value="4" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '4') { echo "selected='selected'"; }?> >4 (Helping staff)</option> </select> <br> <br> <label >9. Designation</label> <select name="desig" id="desig" value=""> </select> <br><br> $desig=($_POST['desig']);

thank you seanlim ...its working

payentry page $str="select MAX(PSRN) from paymajor"; $result=mysql_query($str) or die(mysql_error()); while($row=mysql_fetch_assoc($result)) { $psrn=$row['MAX(PSRN)']+1; } $query = "INSERT INTO `paymajor` ......... $result = mysql_query($query) or die ("Error in query: $query"); if($result) { header ('Location: http://localhost/bitssap/success.php?psrn=' .$psrn); } success page <?php session_start(); $psrn = $_GET['psrn']; ?> <html> <head> <title>Success</title> </head> <hr style="color:#33FF00"> <center> <h1 style="color:#000099">Data entered successfully. The PSRN generated is $psrn</h1> </head> <body bgcolor="#CCCCCC"> <input type="button" name="submit2" value="Pay Entry" onclick='window.location="http://localhost/bitssap/payentry.php"' /> <input type="button" name="submit2" value="Main Menu" onclick='window.location="http://localhost/bitssap/index.php"' /> </center> </body> </html>

yes when i am using onChange event and if i select any employee type it is working ...values are changing ............but if i replace it with onLoad nothing is happing, even the values are not coming

how to use it through URL....I HAVE CUT AND PASTE YOUR CODE but its not working for me

I allready tried this one ....this thing is not working for me......

Hello friends i am working on payentry page ..there i have this code......... $str="select MAX(PSRN) from paymajor"; $result=mysql_query($str) or die(mysql_error()); while($row=mysql_fetch_assoc($result)) { $psrn=$row['MAX(PSRN)']+1; } i need to print $psrn value in the success page......for that i am using header ('Location: http://localhost/bitssap/success.php'); but after success its showing this meassage Data entered successfully. The PSRN generated is $psrn i am not able to print the value of psrn on success page can anybody suggest me how to do this...

hello seanlim thanks for replying..... i am new in programming........can you suggest me how to use onLoad event in this case

Hello friends: i am having javascript , that is working but the problem here is its not working when we are loading the page first time or when we refresh the form.................it is working as soon as we select any of employee type...please go through the code and help me........i think i am not using onchange event correctly in employee type <script language="javascript"> function addOption(selectList,optionText,optionValue) { var newOption = document.createElement('OPTION'); newOption.text = optionText; newOption.value = optionValue; selectList.options.add(newOption); } function changeList(list1,list2) { list2.length = 0; if(list1.options[list1.selectedIndex].value == 2) { addOption(list2,"ACTD","ACTD"); addOption(list2,"ALEC","ALEC"); addOption(list2,"ASOP","ASOP"); addOption(list2,"ASTP","ASTP"); addOption(list2,"DIRO","DIRO"); addOption(list2,"DLIB","DLIB");addOption(list2,"LECT","LECT"); addOption(list2,"PFAT","PFAT"); addOption(list2,"PROF","PROF");addOption(list2,"TA","TA"); addOption(list2,"VFAC","VFAC"); addOption(list2,"VPRF","VPRF"); } else if(list1.options[list1.selectedIndex].value == 3) { addOption(list2,"ACCO","ACCO"); addOption(list2,"APRG","APRG"); addOption(list2,"ASTR","ASTR"); addOption(list2,"COCH","COCH"); addOption(list2,"CSHR","CSHR"); addOption(list2,"CTOR","CTOR"); addOption(list2,"DRVR","DRVR"); addOption(list2,"DUDT","DUDT"); addOption(list2,"ELER","ELER"); addOption(list2,"FINO","FINO"); addOption(list2,"HSPT","HSPT"); addOption(list2,"JAAT","JAAT"); addOption(list2,"JOAT","JOAT"); addOption(list2,"JTEC","JTEC"); addOption(list2,"LABT","LABT"); addOption(list2,"LBST","LBST"); addOption(list2,"LIST","LIST");addOption(list2,"MEDA","MEDA"); addOption(list2,"MO","MO"); addOption(list2,"OFST","OFST"); addOption(list2,"PA","PA");addOption(list2,"PAST","PAST");addOption(list2,"PRGR","PRGR"); addOption(list2,"SCOP","SCOP"); addOption(list2,"SLAT","SLAT"); addOption(list2,"SMDA","SMDA"); addOption(list2,"SMDO","SMDO"); addOption(list2,"SNRS","SNRS"); addOption(list2,"STCH","STCH");addOption(list2,"SUPV","SUPV"); addOption(list2,"WSPT","WSPT"); } else if(list1.options[list1.selectedIndex].value == 4) { addOption(list2,"ATDT","ATDT");addOption(list2,"CHWK","CHWK"); addOption(list2,"LIDT","LIDT"); addOption(list2,"NRSE","NRSE"); addOption(list2,"OAST","OAST"); } } </script> <br><br> <label>3. Employee Type</label> <font color="##FF0000" >*</font> <select name="emptyp" onChange="changeList(document.forms.form2.emptyp,document.forms.form2.desig)"> <option value="2" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '2') { echo "selected='selected'"; }?> >2 (Teaching faculty)</option> <option value="3" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '3') { echo "selected='selected'"; }?> >3 (Supporting staff)</option> <option value="4" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '4') { echo "selected='selected'"; }?> >4 (Helping staff)</option> </select> <br> <br> <label >9. Designation</label> <select name="desig"> </select> <br><br>