asked on
<?php
$con = mysql_connect(localhost, root, 1234567);
if (!$con){
die('Could not connect: ' . mysql_error());
}
mysql_select_db(final)or die('"cannot select DB"');
$resultdowntime = mysql_query("SELECT SUM(gaptime) AS totalGaptime FROM machine1 HAVING gaptime > 1");
$rdowntime=mysql_fetch_array($resultdowntime);
echo $rdowntime['totalGaptime'];
?>
CREATE TABLE machine1 (
ID INT NOT NULL auto_increment,
Date varchar(20),
Time varchar(20) NOT NULL default '',
GapTime TIME NOT NULL,
MachineNumber varchar(20) NOT NULL default '',
PRIMARY KEY (ID)
)type=myisam auto_increment=1;