i just want to retrieve the datas already stored in db and make it editable..
please help.........
below is my php file i wnt to retrieve data back into this form itself ..........from mysql db
Code: Select all
<form name="form1" id="form1" method="post" action="l.php">
<b>
PATIENT NAME
                       
<input name="pat_patname" id="pat_patname" type="text">
   
          DATE:   
<?php
$d=date("d/m/y");
echo $d;
?>
<br>
<br>ADDRESS<br>
                                                     
<TEXTAREA name="pat_address" id="pat_address" cols="17" rows="6">
</textarea>
<BR>
<BR>
CITY/TOWN                              
<input name="pat_city" id="pat_city" type="text">
      <br><br>
STATE                                        
<select name="pat_state" id="pat_state" >
<option value="AP">AP</option>
<option value="UP">UP</option>
<option value="TN">TN</option>
<option value="MP">MP</option>
<option value="JK">JK</option>
<option value="KR">KR</option>
<option value="KL">KL</option>
<option value="AS">AS</option>
</select>
<br><br>
AGE                                            
<select name="pat_age" id="pat_age">
<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">5</option>
<option value="7">7</option>
<option value="8">8</option>
</select>
                                              
          
<br><br>SEX                                           
<INPUT type="radio" name="pat_sex" value="Male" checked> Male
   
<INPUT type="radio" name="pat_sex" value="Female"> Female<BR><BR>
CONTACT NUMBER              
<input name="pat_contactno" name="pat_contactno" type="text">
<BR>
<BR>
REFERENCE DETAILS          
<input name="refr" type="text">
<BR>
<BR>
INSURANCE DETAILS
<BR><br>
INSURANCE PROVIDER         
<select name="inpro" >
<option value="NULL">-NIL-</option>
<option value="STAR">STAR</option>
<option value="LIC">LIC</option>
<option value="HDFC">HDFC</option>
<option value="AXIS">AXIS</option>
</select>
                                      INSURANCE ID            
<input name="inid" type="text">
<br><br><br>
<center><input name="save" type="submit" id="save" value="Save"> 
<INPUT type="RESET"> 
<input type="button" value="Back" > </center>
</form>