database_query($sql) or $em=$em.$database->database_error(); } elseif($ps==1) { $sql="UPDATE ".$table_name." SET ".$fieldname." = AES_ENCRYPT(".GetSQLValueString($fieldvalue, $dtype).",'".$wordgames."') WHERE id = ".$therowid; $query=$database->database_query($sql) or $em=$em.$database->database_error(); } elseif($ps==2) { } elseif($ps==3) { } elseif($ps==4) { if($fieldvalue==1){$fieldvalue="Y";}else{$fieldvalue="N";} $sql="UPDATE ".$table_name." SET ".$fieldname."=".GetSQLValueString($fieldvalue, $dtype)." WHERE id = ".$therowid; $query=$database->database_query($sql) or $em=$em.$database->database_error(); } $arr = array ('error'=>$em); echo json_encode($arr); //Philip Poremba 05/02/2012 ?>