Re: Query and exporting to csv

2012-06-30 Thread lowpass
d, calls.id call_id, >> patients.first_name, patients.last_name, calls.created ' >>      . 'FROM drugs, drug_lactation_links, lactation, calls, patients ' >>      . 'WHERE drugs.id = ' . $id . ' AND drugs.id = >> drug_lactation_links.drug_id AND ' >

Re: Query and exporting to csv

2012-06-30 Thread lowpass
_pregnancy_links, pregnancies, calls, patients ' >      . 'WHERE drugs.id = ' . $id . ' AND drugs.id = > drug_pregnancy_links.drug_id AND ' >      . 'drug_pregnancy_links.pregnancy_id = pregnancies.id AND > pregnancies.call_id = calls.id AND calls.patient_id = p

Query and exporting to csv

2012-06-29 Thread Shosho
all_id = calls.id AND calls.patient_id = patients.id ' . 'ORDER BY created DESC' ); $this->set(compact('patients')); } View: addRow(array('Enter Generic: ' . $drug['Drug']['generic'])); $csv->addRow($header)