"; } if ($hasWriteAccess) { $edit_link = ""; } if ($hasExecuteAccess) { $delete_link = ""; } $space = "   "; $links = $assign_link . $space . $view_link . $space . $edit_link . $space . $delete_link; $data['rows'][] = array( 'id' => $row['prescription_id'], 'cell' => array( $count++, $links, getTableFieldValue('ailment', 'ailment_name', 'ailment_id', $row['diagnosis']), getTableFieldValue('abnormality', 'abnormality_name', 'abnormality_id', $row['diseases']), getTableFieldValue('tbl_items', 'item_name', 'item_id', $row['medicine_name']), getTableFieldValue('medicine_frequency', 'medicine_frequency', 'frequency_id', $row['medicine_frequency']), getTableFieldValue('medicine_timings', 'medicine_timing', 'timing_id', $row['medicine_timing']), getTableFieldValue('dosage_category', 'dosage_category', 'dosage_category_id', $row['admin_route']), $row['duration'], $row['dose_qty'], getCommaSeperatedValuesForInClause("select health_advice_name from health_advice", 'health_advice_id', $row['health_advices']) ) ); } // error_log(print_r($data, true)); echo json_encode($data); ?>