นำข้อมูลในฐานข้อมูลมาบวกกัน โดยหากยังไม่มีการคำนวณให้แสดงข้อมูลที่อยู่ในฐานข้อมูลก่อน

CREATE TABLE `editeaf` (
  `id` int(5) NOT NULL auto_increment,
  `t3` float NOT NULL,
  `t4` float NOT NULL,
  `c3` float NOT NULL,
  `c4` float NOT NULL,
  `c5` float NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `bpk-t3` (`t3`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

-- 
-- dump ตาราง `editeaf`
-- 

INSERT INTO `editeaf` VALUES (1, 12, 23, 23, 23, 24, '2015-06-26 15:37:40');
INSERT INTO `editeaf` VALUES (2, 12, 12, 12, 12, 12, '2015-06-26 13:39:08');
INSERT INTO `editeaf` VALUES (3, 143, 145, 33, 12, 456, '2015-06-29 09:06:54');
INSERT INTO `editeaf` VALUES (4, 2, 2, 2, 2, 2, '2015-06-29 09:11:25');
INSERT INTO `editeaf` VALUES (5, 1, 1, 1, 1, 1, '2015-06-29 09:12:22');
INSERT INTO `editeaf` VALUES (6, 45, 45, 45, 45, 45, '2015-06-29 09:45:40');

<?php
 
include"database.php";
$show_edit=" select * from editeaf order by date desc limit 0,1 ";
$result = mysql_db_query($dbname,$show_edit);
$record = mysql_fetch_array($result);
?>
<form enctype="multipart/form-data" name="formx" class="er" method="post">
  <p> <a href="output.php"></a>
  </p>
  <p>&nbsp;</p>
  <table width="913" height="234" border="2" align="center">
    <tr>
      <th colspan="6" align="right">วันที่อัพเดตล่าสุด
        <label for="update"></label>
      <input name="update" type="text" id="update" size="30" readonly="readonly" value="<?php echo"$record[date]";?>"/></th>
    </tr>
    <tr bgcolor="#FFFF00">
      <th width="149" bgcolor="#CC00FF"><strong>p1</strong></th>
      <th width="144" bgcolor="#CC00FF"><strong>p2</strong></th>
      <th width="144" bgcolor="#CC00FF"><strong>p3</strong></th>
      <th width="144" bgcolor="#CC00FF"><strong>p4</strong></th>
      <th width="144" bgcolor="#CC00FF"><strong>p5</strong></th>
      <th width="146" bgcolor="#CC00FF"><strong>sum</strong></th>
    </tr>
    <tr>
      <td height="26">T3</td>
      <td><label for="fileField"><?php { echo $total ; } ?></label></td>
      <td><input type="text" name="poht3"  autocomplete="off" value="<?php echo $_POST['poht3']; ?>"  /></td>
      <td><input type="text" name="uoht3"  autocomplete="off" value="<?php echo $_POST['uoht3']; ?>"/></td>
      <td><input type="text" name="eudht3" autocomplete="off" value="<?php echo $_POST['eudht3']; ?>" /></td>
      <td bgcolor="#FF6699"> <?php {
@$sum= (($total - $poht4 - $uoht4 - $eudht4)/$total) *100;//ช่องที่ใช้คำนวน ต้องการนำเลข45 มาคูณแทน100 แต่ถ้าหากยังไม่ได้คลิกคำนวนให้ในช่องนี้ขึ้นเลข45โชว์ไว้ก่อน
 echo round($sum,3) ;  } ?></td>
    </tr>
    <tr>
      <td height="26">T4</td>
      <td><label for="pohc4"><?php { echo $total ; } ?></label></td>
      <td><input type="text" name="poht4" autocomplete="off" value="<?php echo $_POST['poht4']; ?>"/></td>
      <td><input type="text" name="uoht4"  autocomplete="off" value="<?php echo $_POST['uoht4']; ?>" /></td>
      <td><input type="text" name="eudht4" autocomplete="off" value="<?php echo $_POST['eudht4']; ?>" /></td>
      <td bgcolor="#FF6699"><?php {
@$sum = (($total - $poht4 - $uoht4 - $eudht4)/$total) *100; 
 echo round($sum,3) ;  } ?></td>
    </tr>
    <tr>
      <td height="26">C3</td>
      <td><label for="pohc4"><?php { echo $total ; } ?></label></td>
      <td><input type="text" name="pohc3" autocomplete="off" value="<?php echo $_POST['pohc3']; ?>" /></td>
      <td><input type="text" name="uohc3"autocomplete="off" value="<?php echo $_POST['uohc3']; ?>" /></td>
      <td><input type="text" name="eudhc3" autocomplete="off" value="<?php echo $_POST['eudhc3']; ?>" /></td>
      <td bgcolor="#FF6699"><?php {
@$sum = (($total - $pohc3 - $uohc3 - $eudhc3)/$total) *100;
 echo round($sum,3) ;  } ?></td>
    </tr>
    <tr>
      <td height="26">C4</td>
      <td><label for="pohc4"></label><?php {  echo $total ; } ?></td>
      <td><input type="text" name="pohc4" autocomplete="off" value="<?php echo $_POST['pohc4']; ?>" /></td>
      <td><input name="uohc4" type="text"  autocomplete="off" value="<?php echo $_POST['uohc4']; ?>" /></td>
      <td><input type="text" name="eudhc4" autocomplete="off" value="<?php echo $_POST['eudhc4']; ?>" /></td>
      <td bgcolor="#FF6699"><?php {
@$sum= (($total - $pohc4 - $uohc4 - $eudhc4)/$total) *100;
 echo round($sum,3) ;  } ?></td>
    </tr>
    <tr>
      <td height="26">C5</td>
      <td><?php { echo $total ; } ?></td>
      <td><input type="text" name="pohc5" autocomplete="off" value="<?php echo $_POST['pohc5']; ?>" /></td>
      <td><input type="text" name="uohc5" autocomplete="off" value="<?php echo $_POST['uohc5']; ?>" /></td>
      <td><input type="text" name="eudhc5"autocomplete="off" value="<?php echo $_POST['eudhc5']; ?>" /></td>
      <td bgcolor="#FF6699"><?php {
@$sum = (($total - $pohc5 - $uohc5 - $eudhc5)/$total) *100; 
 echo round($sum,3) ;  } ?></td>
    </tr>
    
    <tr align="center">
      <td height="28" colspan="6"><input name="ok" type="submit" class="er" id="ok" value="calculate" />
   <input name="exit" type="button" class="er" id="exit" value="clear" /></td>
    </tr>
   
  </table>