$sql_bdd on the server $sql_server"; exit;} $requete=mysql_db_query($sql_bdd,"select * from user_divawards where Aw_Id=\"$leg_num\"",$db_link) or die(mysql_error()); if(mysql_num_rows($requete)==0) { header("Location:noawards.php?Id=$leg_num"); exit; } $Aw_Name=mysql_result($requete,0,"Aw_Name"); $Aw_Div=mysql_result($requete,0,"Aw_Div"); $Aw_Person=mysql_result($requete,0,"Aw_Person"); $Aw_Vid=mysql_result($requete,0,"Aw_Vid"); $Aw_Text=mysql_result($requete,0,"Aw_Text"); $Aw_Date=mysql_result($requete,0,"Aw_Date"); $jj = substr($Aw_Date, 0, 2); $mm = substr($Aw_Date, 3, 2); $aa = substr($Aw_Date, 6, 4); $person1=mysql_db_query($sql_bdd,"select Pers_First_Name, Pers_Last_Name from user_data where Pers_Id=\"$Aw_Person\"",$db_link) or die(mysql_error()); $person1b = mysql_fetch_array($person1); $name_1 = $person1b[Pers_Last_Name]; $surname_1 = $person1b[Pers_First_Name]; $person2=mysql_db_query($sql_bdd,"select Pers_First_Name, Pers_Last_Name from user_data where Pers_Id=\"$Aw_Vid\"",$db_link) or die(mysql_error()); $person2b = mysql_fetch_array($person2); $name_2 = $person2b[Pers_Last_Name]; $surname_2 = $person2b[Pers_First_Name]; $person3=mysql_db_query($sql_bdd,"select name from divawards_list where letter=\"$Aw_Name\"",$db_link) or die(mysql_error()); $person3b = mysql_fetch_array($person3); $name_leg = $person3b[name]; $selectdivision=mysql_db_query($sql_bdd,"select * from division order by name",$db_link) or die(mysql_error()); $this_year = date("Y"); $this_year = $this_year + 1; mysql_close($db_link); include("staff.php"); if($Func_staff_PRE==1 OR $Func_staff_DIR==1 OR $Func_staff_MD==1) { } else { header("Location:http://www.ivao.org/noaccess.php"); exit; } ?> Division Awards Update

Division Awards Update

 

Awards :
By : '.$Aw_Person.' - '.$surname_1.' '.$name_1.''; ?>
To : '.$Aw_Vid.' - '.$surname_2.' '.$name_2.''; ?>
Division :
Comments :
Date : //