{
$res = mysql_query("SELECT test_id,test_name FROM wc_range as r INNER JOIN wc_testbattery_test_attribute as tta ON\n\t\t\t\ttta.testbattery_id =r.rangetestbattery_id INNER JOIN wc_test as t On t.test_id = tta.testbattery_test_id \n\t\t\t\tWHERE range_id = '" . $this->rangeid . "'") or die(mysql_error());
return $res;
}
}
//To insert data
if (isset($_GET['adddata'])) {
$counter = (count($_POST) - 3) / 3;
$rangeFunction = new rangeFunction();
$rangeFunction->rangetestbatteryid = $_POST['range_testbattery'];
$rangeFunction->rangecategoryid = $_POST['range_category'];
$rangeFunction->rangetestid = $_POST['range_test'];
$rangeFunction->rangetestattributeid = $_POST['range_parameter'];
$testname = mysql_fetch_array($rangeFunction->testnameSelect());
$rangeFunction->rangetestname = $testname['test_name'];
$paramters = $rangeFunction->isParameterExist();
if (!$paramters) {
$rangeinsert = $rangeFunction->rangeInsert();
if ($rangeinsert) {
for ($i = 1; $i <= $counter; $i++) {
$rangeFunction->rangeid = $rangeinsert;
$rangeFunction->rangestart = $_POST["range_start" . $i . ""];
$rangeFunction->rangeend = $_POST["range_end" . $i . ""];
$rangeFunction->rangepoint = $_POST["range_points" . $i . ""];
$rangeattrinsert = $rangeFunction->rangeattributeInsert();
}
echo "success#Range Inserted#" . $rangeinsert . '#' . $rangeFunction->rangetestname;
} else {
echo "failure#Range Not Inserted";
}
} else {
