define("valid",1);
$fac_id=$_POST['fac_id'];
$dept_id=$_POST['dept_id'];
$grant_day=$_POST['grant_day'];
$grant_month=$_POST['grant_month'];
$grant_year=$_POST['grant_year'];
$grant_date=$grant_year."-".$grant_month."-".$grant_day;
$prefix_name=$_POST['prefix_name'];
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$positions=$_POST['positions'];
$phones=$_POST['phones'];
$emails=$_POST['emails'];
$manager_name=$_POST['manager_name'];
$manager_pos=$_POST['manager_pos'];
$plan_grant=$_POST['plan_grant'];
$stock_grant=$_POST['stock_grant'];
$money_grant=$_POST['money_grant'];
$descripts=$_POST['descripts'];
if($_POST['submits']){
$sql="insert into regis_grant values('','$fac_id','$dept_id','$grant_date','$prefix_name','$fname','$lname','$positions','$phones','$emails','$manager_name','$manager_pos','$plan_grant','$stock_grant','$money_grant','$descripts','','$statuss',now())";
mysql_query($sql,$conn);
$sql="select max(grant_id) as grant_id from regis_grant";
$result=mysql_query($sql,$conn);
$result_row=mysql_fetch_object($result);
mysql_free_result($result);
$gen_code=$result_row->grant_id.rand(0,10000);
$sql="update regis_grant set gen_code='$gen_code' where grant_id='$result_row->grant_id'";
mysql_query($sql,$conn);
echo "";
}
?>