function update_student($params)
{
[red]$DLapp = isset($_POST['DLApp'])?1:0 ;
$DLPros = isset($_POST['DLPros'])?1:0;
$Reg = isset($_POST['Registered'])?1:0;[/red]
$connection = db_connect();
$query = sprintf("update students
set
Surname = '%s',
FirstName = '%s',
Email = '%s',
Street = '%s',
Suburb = '%s',
City = '%s',
PCode = '%s',
State = '%s',
Comments = '%s',
Phone = '%s',
Login = '%s',
Pwd = '%s',
[red]DLApp = $DLapp,
DLPros = $DLPros,
Registered = $Reg,[/red]
UDBy = '%s'
where
StudentID = '%s'
",
mysql_real_escape_string($params['Surname']),
mysql_real_escape_string($params['FirstName']),
mysql_real_escape_string($params['Email']),
mysql_real_escape_string($params['Street']),
mysql_real_escape_string($params['Suburb']),
mysql_real_escape_string($params['City']),
mysql_real_escape_string($params['PCode']),
mysql_real_escape_string($params['State']),
mysql_real_escape_string($params['Comments']),
mysql_real_escape_string($params['Phone']),
mysql_real_escape_string($params['Login']),
mysql_real_escape_string($params['Pwd']),
mysql_real_escape_string($params['UDBy']),
mysql_real_escape_string($params['StudentID'])
);
$result = mysql_query($query);
if(!$result){
return false;
//echo mysql_error();
}else{
return true;
//echo mysql_error();
}
}