I am using the scheduler with php/mysql integration.
I am NOT using a custom form.
In my php file I pull all my fields from a mysql table like this:
$scheduler->render_sql(“select * from events_rec where office_ID IN (”.$office_id.") AND Company_ID = ‘" . addslashes($_SESSION[‘Company_ID’]) . "’",“event_id”,“start_date,end_date,text,rec_type,event_pid,event_length,office_ID,reason,patient_ID,name, howheard_ID,promo_ID, company_ID”);
Everything works great, but I am trying to always assign a value to ‘company_ID’. When an event is created I ALWAYS want the session id ‘Company_ID’ value to be mapped to the “company_ID” field without having this information in the form.
How can I do this? Thanks.