define("valid",1);
$gen_code=$_POST['gen_code'];
$sql="select * from regis_grant where gen_code='$gen_code' and statuss!=1";
$result=mysql_query($sql,$conn);
$result_row=mysql_fetch_object($result);
$chk=mysql_num_rows($result);
mysql_free_result($result);
$fac_id=$_POST['fac_id'];
if($fac_id==""){
$fac_id=$result_row->fac_id;
}
$dept_id=$_POST['dept_id'];
if($dept_id==""){
$dept_id=$result_row->dept_id;
}
$grant_day=$_POST['grant_day'];
if($grant_day==""){
$grant_day=substr($result_row->grant_date,8,2);
}
$grant_month=$_POST['grant_month'];
if($grant_month==""){
$grant_month=substr($result_row->grant_date,5,2);
}
$grant_year=$_POST['grant_year'];
if($grant_year==""){
$grant_year=substr($result_row->grant_date,0,4);
}
$grant_date=$grant_year."-".$grant_month."-".$grant_day;
$prefix_name=$_POST['prefix_name'];
if($prefix_name==""){
$prefix_name=$result_row->prefix_name;
}
$fname=$_POST['fname'];
if($fname==""){
$fname=$result_row->fname;
}
$lname=$_POST['lname'];
if($lname==""){
$lname=$result_row->lname;
}
$positions=$_POST['positions'];
if($positions==""){
$positions=$result_row->positions;
}
$phones=$_POST['phones'];
if($phones==""){
$phones=$result_row->phones;
}
$emails=$_POST['emails'];
if($emails==""){
$emails=$result_row->emails;
}
$manager_name=$_POST['manager_name'];
if($manager_name==""){
$manager_name=$result_row->manager_name;
}
$manager_pos=$_POST['manager_pos'];
if($manager_pos==""){
$manager_pos=$result_row->manager_pos;
}
$plan_grant=$_POST['plan_grant'];
if($plan_grant==""){
$plan_grant=$result_row->plan_grant;
}
$stock_grant=$_POST['stock_grant'];
if($stock_grant==""){
$stock_grant=$result_row->stock_grant;
}
$money_grant=$_POST['money_grant'];
if($money_grant==""){
$money_grant=$result_row->money_grant;
}
$descripts=$_POST['descripts'];
if($descripts==""){
$descripts=$result_row->descripts;
}
$statuss=$_POST['statuss'];
if($statuss==""){
$statuss=$result_row->statuss;
}
if($_POST['submits']){
$sql="update regis_grant set fac_id='$fac_id',dept_id='$dept_id',grant_date='$grant_date',prefix_name='$prefix_name',fname='$fname',lname='$lname',positions='$positions',phones='$phones',emails='$emails',manager_name='$manager_name',manager_pos='$manager_pos',plan_grant='$_POST[plan_grant]',stock_grant='$_POST[stock_grant]',money_grant='$_POST[money_grant]',descripts='$descripts',date_save=now() where gen_code='$gen_code'";
mysql_query($sql,$conn);
echo "";
}
?>