Forum Moderators: coopster
<html>
<head>
<title>Get Status</title>
</head>
<body>
<?php
// Disbale eror reporting error_reporting(E_ALL ^ E_NOTICE);
$con = mysql_connect('localhost','test','Test');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
$query = "Select count(TS.status) as STATUS,TS.status as STAT,tcv.priority from TESTCYCLE TC, TESTCASE_VERSION TCV,
TESTCASE_STATUS TS where
TS.status = 'Pass' and
TC.id = TS.testcycle_id and
TCV.testcase_id = TS.testcase_id and
TC.name = 'testcycle1'
group by TCV.priority";
$result1 = mysql_query($query) or die(mysql_error());
if($result1 === FALSE) {
die(mysql_error()); // TODO: better error handling
}
while($row1 = mysql_fetch_array($result1))
{
echo $row1['STATUS']. " - ". $row1['STAT'];
echo "<br />";
}
mysql_close($con);
?>
</body>
</html>
