รบกวนช่วยดูโค๊ต UPDATE และ IF ให้หน่อยครับว่าผิดตรงไหน คือผมต้องการอัพเดทข้อมูลที่ได้จากการ query ลงอีก table หนึ่ง

while($objResult5 = mysql_fetch_array($objQuery5))
{

$result = mysql_query("update dailysale set totally = '".$objResult5["sumtotal"]."' where shopcode = '".$objResult5["shopcode"]."'");
$objQuery = mysql_query($result);
if(!$objQuery)

<?PHP
$strSQL4 = "SELECT SUM(total) AS sumtotal , stdrecord.shopcode ,user.branch FROM stdrecord INNER JOIN user On stdrecord.shopcode=user.user WHERE stdrecord.date = '".$addprintdate."' AND user.zone='".$objResult1["zone"]."' GROUP BY stdrecord.shopcode ";
$objQuery4 = mysql_query($strSQL4) or die ("Error Query [".$strSQL4."]");
while($objResult4 = mysql_fetch_array($objQuery4))
{


$strSQL3 = "
INSERT INTO dailysale (shopcode,totalty,useram,branch)
VALUES
('".$objResult4["shopcode"]."','".$objResult4["sumtotal"]."','".$objResult1["zone"]."','".$objResult4["branch"]."') 
";
mysql_query($strSQL3) or die(mysql_error());



}

$strSQL5 = "SELECT SUM(total) AS sumtotal , stdrecord.shopcode ,user.branch FROM stdrecord INNER JOIN user On stdrecord.shopcode=user.user WHERE stdrecord.date = '".$lastyear."' AND user.zone='".$objResult1["zone"]."' GROUP BY stdrecord.shopcode ";
$objQuery5 = mysql_query($strSQL5) or die ("Error Query [".$strSQL5."]");
while($objResult5 = mysql_fetch_array($objQuery5))
{
	
	$chkData = mysql_query("SELECT shopcode FROM dailysale where shopcode = '".$objResult5["shopcode"]."' ");
	if(mysql_num_rows($chkData)>0){
		mysql_query("update dailysale set totally = '".$objResult5["sumtotal"]."' where shopcode = '".$objResult5["shopcode"]."'");
	} else {
		$strSQL21 = "INSERT INTO dailysale (shopcode,totally,useram,branch) VALUES ('".$objResult5["shopcode"]."','".$objResult5["sumtotal"]."','".$objResult1["zone"]."','".$objResult5["branch"]."') ";
		mysql_query($strSQL21) or die(mysql_error());
	}

}
?>

	   $strSQL5 = "SELECT SUM(total) AS sumtotal , stdrecord.shopcode ,user.branch FROM stdrecord INNER JOIN user On stdrecord.shopcode=user.user WHERE stdrecord.date = '".$lastyear."' AND user.zone='".$objResult1["zone"]."' GROUP BY stdrecord.shopcode ";
   $objQuery5 = mysql_query($strSQL5) or die ("Error Query [".$strSQL5."]");
   $objQuery5  = mysql_query($strSQL5);
   while($objResult5 = mysql_fetch_array($objQuery5))
	{
             $strSQLchk = "SELECT * FROM dailysale WHERE shopcode = '".$objResult5["shopcode"]."' ";
             $objQuerychk = mysql_query($strSQLchk);
			 $Num_Rowschk = mysql_num_rows($objQuerychk);
             $objResultchk = mysql_fetch_array($objQuerychk);
       
		
		if($Num_Rowschk > 0)
			
{
			 $result = mysql_query("update dailysale set totally = '".$objResult5["sumtotal"]."' where shopcode = '".$objResult5["shopcode"]."'");
		
		$objQueryupdate = mysql_query($result);
}
        else 
		{ 
		 $strSQL21 = "
				INSERT INTO dailysale (shopcode,totally,useram,branch)
				VALUES
				('".$objResult5["shopcode"]."','".$objResult5["sumtotal"]."','".$objResult1["zone"]."','".$objResult5["branch"]."') 
			  ";
			 mysql_query($strSQL21) or die(mysql_error());
			
		}

$objQuery5 = mysql_query($strSQL5) or die ("Error Query [".$strSQL5."]");
   $objQuery5  = mysql_query($strSQL5);

select  b.* , coalesce(a.id, 'new' ) as chk_a from b left join a on a.id=b.id

if( $ro['chk_a']=='new' ) insert into a
else update a set ........ where id='$ro['chk_a']