27 lines
1.1 KiB
PHP
27 lines
1.1 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
|
|
$checkup_section_id=$_REQUEST['checkup_section_id'];
|
|
$sid=$_REQUEST['selectid'];
|
|
$act_filter='';
|
|
if($checkup_section_id!='' && $checkup_section_id!=null){
|
|
$act_filter=' where activity="'.$checkup_section_id.'"';
|
|
}
|
|
// $question_category = $_POST['checkup_section_id'];
|
|
// if (!empty($question_category)) {
|
|
$query = "select concat(parameter_name,'-',(select program_name from program_master where program_id=a.activity )) as pro_act,column_name from checkup_parameter a $act_filter";
|
|
$result = mysqli_query($conn, $query);
|
|
error_log("query ky" . $query);
|
|
?>
|
|
<option value="" disabled selected>Select Parameter</option>
|
|
<?php
|
|
while ($row = mysqli_fetch_assoc($result)) {
|
|
// $key_param = getFieldFromTable('key_param_name', 'key_health_reportable_parameter_master', 'key_param_id', $row['key_health_map_name']);
|
|
error_log("param name key" .$key_param);
|
|
?>
|
|
<option value="<?php echo $row['column_name']; ?>" <?php if($sid==$row['column_name']) echo 'Selected' ?> ><?php echo $row['pro_act']; ?></option>
|
|
<?php
|
|
}
|
|
// }
|
|
?>
|