UPDATE

<?php
session_start();
require ('../Connections/ukomdb.php');

require ('upload.php');

if (isset($_POST['Submit'])) {
$sql = mysql_query("SELECT MAX(no_baru_tahun) as jml,ukom_tgltest ,app_status FROM db_master_tki WHERE app_status ='TEST1'");
$r = mysql_fetch_array($sql);
if ($r['jml'] > 0) {
$sql2 = mysql_query("SELECT MAX(no_baru_tahun) as jml, app_status FROM db_master_tki WHERE app_status ='TEST1'");
$rs = mysql_fetch_array($sql2);

$noMax = $rs['jml'];
// echo "besar - ";
// echo "$noMax - ";
$noMax = $noMax + 1;
// echo "$noMax";
// SQL UPDATE
} else {
$noMax = 1;
// echo "kecil - ";
// echo "$noMax";
// SQL UPDATE
}
$uploadfile = str_replace("./", "", $uploadfile);
$updt = "UPDATE db_master_tki set tki_foto2 ='" . $uploadfile . "', no_baru_tahun ='" . $noMax . "', app_status='SERTIFIKAT PRINT' WHERE id_tki ='" . $_GET['id_tki'] . "'";

$rt = mysql_query($updt) or die(mysql_error());
//echo '[removed]window.close();[removed]';
}
?>