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()
{
