การคำนวณบน Loop If แบบธรรมดาแต่ติดปัญหา หาผู้รู้เข้ามาแนะนำหน่อยครับ

$link = mysql_connect("localhost", "root", "1234");
    $sqlC = "use thesis";
	mysql_query("SET NAMES utf8");
    $result=mysql_query($sqlC);
	$sqlC = "select MAX(Subject_id) as MAX from subject where (Subject_ID Like '%$subject_id%') " ;
	$queryC = mysql_query($sqlC);
	$numC = mysql_num_rows($queryC);
	$result = mysql_fetch_array($queryC);
	$subject_id2 = $subject_id;
	if ($numC == 1)
	{	
		$msg1 = $result['MAX'];
		$msg1 = $msg1+1;
		$subject_id = $msg1;
		if($subject_id == "1"){
			$subject_id = $subject_id2."001";
			}
		}
	

$link = mysql_connect("localhost", "root", "1234");
    $sqlC = "use thesis";
	mysql_query("SET NAMES utf8");
    $result=mysql_query($sqlC);
	$sqlC = "select MAX(Exam_id) as MAX from examination where (Exam_ID Like '%$button%') " ;
	$queryC = mysql_query($sqlC);
	$numC = mysql_num_rows($queryC);
	$result = mysql_fetch_array($queryC);
	$exam_id2 = $button;
	
	if($numC== 1)
	{
		$msg1 = $result['MAX'];
		$msg1 = $msg1+1;
		$exam_id = $msg1;
	}if($exam_id == "1"){
			$exam_id = $exam_id2."001";
		}
		
	}