tech_plan_tb */ $query1 = " SELECT * FROM $myTable2 WHERE carId='$carId' AND Teacher_code='$Teacher_code' "; $result1 = $dbObj->execQuery($query1); $rs1 = $dbObj->fetchArray($result1); $query = " SELECT * FROM $myTable1 WHERE Teacher_code='$rs1[Teacher_code]' "; $result = $dbObj->execQuery($query); $rss = $dbObj->fetchArray($result); //$Teacher_code = $rss['Teacher_code']; /** Table --> techplan_method_tb */ $query2 = " SELECT * FROM $myTable3 WHERE ProvinceId='$rs1[ProvinceId]' "; $result2 = $dbObj->execQuery($query2); $rs2 = $dbObj->fetchArray($result2); ?>