ช่วยด้วยค่ะ ต้องการรวมจำนวนหนังสือที่ชำรุด สูญหาย แต่ไม่รู้จะนับรวมยังไงอ่ะค่ะ ช่วยมาดูให้หน่อยนะค่ะ

<style type="text/css">
<!--
.style1 {font-size: 18px}
.style2 {font-size: 14px}
.style3 {
	font-size: 24px;
	color: #FF0000;
}
.style4 {font-size: 12px}
-->
</style>
	 
     
<p align="center" class="style3">แจ้งชำรุด สูญหาย</span></p>
<table width="671" align="center">        
                <tr height="25" >
                  <td bgcolor="#6B6F72"><div align="center"></div></td>
                  <td bgcolor="#6B6F72"><div align="center"><span class="style2 style1">ชื่อหนังสือ</span></div></td>
                  <td width="80" bgcolor="#6B6F72"><div align="center"><span class="style2 style1">สถิตการยืม</span></div></td>
                  <td width="59" bgcolor="#6B6F72"><div align="center"><span class="style2 style1">ยอดรวม</span></div></td>
                  <td bgcolor="#6B6F72"><div align="center"><span class="style2 style1">ชำรุด</span></div></td>
                    <td bgcolor="#6B6F72"><div align="center"><span class="style2 style1">สูญหาย</span></div></td>
                  <td bgcolor="#6B6F72"><div align="center"><span class="style2 style1">คงเหลือ</span></div></td>
                  <td bgcolor="#6B6F72"><div align="center"><span class="style1"></span></div></td>
                </tr>
		  <? 
		  $db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		  $res[show] = $db->select_query("SELECT * FROM tbl_book");
		  while($arr[show] = $db->fetch($res[show] )){	
?>
                <tr height="25" >
                  <td width="23" bgcolor="#969698"><img src="images/icnuser7.gif" width="20" height="16"></td>
                  <td width="181" bgcolor="#969698"><span class="style2">&nbsp;<? echo $arr[show][book_name]; ?></span></td>
                  <td bgcolor="#969698"><div align="center"><span class="style2">&nbsp;&nbsp;
                  <? ?> 
                  ครั้ง</span> </div></td>
                  <td bgcolor="#969698">
                    <div align="center"><span class="style2">
                    <?=$arr[show][book_num]; ?>
                    </span> </div></td>
                  <td width="56" bgcolor="#969698">
                    <div align="center"><span class="style2">
                    <?
		  $sql_select= $db->select_query("SELECT * FROM tbl_lost WHERE lost_stat='1'and book_no='".$arr[show][book_no]."'");
					$sql_lost = $db->rows($sql_select);
					if($sql_lost>0){
					?>
                
					<img src="images/check-1.gif" width="15" height="14" />
					<?
					}
					?>
                    </span> </div></td>
                      <td width="55" bgcolor="#969698">
                        <div align="center"><span class="style2">
                         <?
		  $sql_select= $db->select_query("SELECT * FROM tbl_lost WHERE lost_stat='2'and book_no='".$arr	[show][book_no]."'");
					$sql_lost = $db->rows($sql_select);
					if($sql_lost>1){
						
					
					?>
					<img src="images/check-1.gif" width="15" height="14" />
					<?
					}
					?>
                        </span> </div></td>
                  <td width="66" bgcolor="#969698">
				    <div align="center"><span class="style2">
			        <? $remain =$arr[show][book_num]-1;?>
			        <?=$remain ?> 
			        </span></div></td>
                  <td width="95" align="center" bgcolor="#969698"><div align="center">  <span class="style4"><a href="?name=admin&amp;file=book_detail&amp;action=lost&book_id=<?=$arr[show][book_no] ;?>&id=1">[ชำรุด]</a> <a href="?name=admin&amp;file=book_detail&amp;action=lost2&book_id=<?=$arr[show][book_no] ;?>&id=2">[สูญหาย]</a> </span></div></td>
             
                </tr>
				    <?
				$totals=$totals+$sql_lost;
			$sum_decay=$sum_decay+$sql_lost2;
			$sum_remain=$sum_remain+$arr[show][book_num];
		}
	
?>
                <tr height="25" >
                  <td bgcolor="#969698">&nbsp;</td>
                  <td bgcolor="#969698"><span class="style2"></span></td>
                  <td bgcolor="#969698"><div align="center"><span class="style2">รวม</span></div></td>
                  <td bgcolor="#969698"><div align="center"><span class="style2"><strong>
                    <?=$sum_remain?>
                  </strong></span></div></td>
                  <td bgcolor="#969698"><div align="center"><span class="style2"><strong>
                     <?=$totals?>
                  </strong></span></div></td>
                  <td bgcolor="#969698"><div align="center"><span class="style2"><strong>
                    <?=$sum_decay ?>
                  </strong></span></div></td>
                       <td bgcolor="#969698"><div align="center"><span class="style2"><strong>
                       <? ?>
                  </strong></span></div></td>
                  <td bgcolor="#969698"><span class="style2"></span></td>
                </tr>
            
                <tr height="25">
                  <td colspan="7" bgcolor="#6B6F72">&nbsp;</td>
                </tr>
                <tr height="25">
               
                  <td colspan="7" bgcolor="#FFFFFF"> 
				  <form name="form1" method="post" action="index2.php?name=admin&file=pint_total" target="_blank"  onSubmit="closewin()">
                    <div align="center">
					
                      <br>
                      <input type="submit" name="Submit" value="พิมพ์สรุปยอดรวม" >
                    </div>
                  </form></td>
                </tr>
                <tr height="25">
                  <td colspan="7" bgcolor="#FFFFFF"><a href="news/news_all.php"></a></td>
                </tr>
</table>
<?
					if($_GET[action]==lost){
					$lost_stat = $_GET['book_id'];
					$sql="insert into tbl_lost set lost_stat='1',book_no='$lost_stat'";
					$re=mysql_query($sql);
					}
					 ?>
<?
					if($_GET[action]==lost2){
					$lost_stat2 = $_GET['book_id'];
					$sql="insert into tbl_lost set lost_stat='2',book_no='$lost_stat2'";
					$re=mysql_query($sql);
					}
					 ?>
					 	<? //echo "<script language='javascript' >window.location = '?name=admin&file=book_detail'</script>";?>

นี่คือโค้ดนะค่ะ