function update_ccdev($update_ccdev_sql) { ehr_connect(); $update_query = mysql_query($update_ccdev_sql) or die("Error 196 : " . mysql_error()); }
unset($push_data_array); } update_m_push($array_m_push_update, 'newconsult'); unset($array_m_push_update); } else { echo "No new consult"; } //other table with consult_id $table_array = array('m_patient_mc', 'm_patient_fp'); //list of secondary table related with consult_id foreach ($table_array as $tablename) { lite_connect($host); $check_status_sql = "SELECT lite_patient_id, emr_patient_id, lite_specific_id, emr_specific_id, table_name, entry_date, sync_type FROM m_push_status WHERE push_flag ='Y' AND table_name='{$tablename}' AND sync_type='N'"; $new_entry_array = get_data_array($check_status_sql); if ($new_entry_array != NULL || $new_consult_array != '') { ehr_connect(); $array_m_push_update = array(); foreach ($new_entry_array as $entry_array => $new_entry) { $new_id = get_new_id($new_entry); $insert_text = insert_values($new_entry, $new_id); insert_query($insert_text, $new_entry[4]); $push_data_array = array($new_entry[0], $new_entry[1], $new_entry[2], $new_id, $new_entry[4], $new_entry[5], 'N', $new_entry[6]); array_push($array_m_push_update, $push_data_array); unset($push_data_array); } update_m_push($array_m_push_update, 'new'); unset($array_m_push_update); } } function insert_query() {