On Thu, May 31, 2012 at 12:55 PM, David OBrien <dgobrien@xxxxxxxxx> wrote: > On Thu, May 31, 2012 at 12:46 PM, Don Wieland <donw@xxxxxxxxxxxxx> wrote: > >> I have a query below. When I try to run it with PHP it errors: >> >> DATABASE_ERROR: You have an error in your SQL syntax; check the manual >> that corresponds to your MySQL server version for the right syntax to use >> near 'LINES TERMINATED BY '\n'' at line 38 IN >> >> BUT where I copy the echoed query and paste into into my Sequel Pro query >> editor and run it - works perfectly. Can someone shone some light on this? >> Frustrating - to say the least. >> >> Don >> >> $csv = "SELECT u.user_id, >> u.first_name AS >> u_first_name, >> u.last_name AS >> u_last_name, >> c.client_id AS >> c_client_id, >> c.first_name AS >> c_first_name, >> c.middle_name AS >> c_middle_name, >> c.last_name AS >> c_last_name, >> c.address AS >> c_address, >> c.city AS c_city, >> c.state AS c_state, >> c.zip AS c_zip, >> c.dob AS dob_ymd, >> c.phone_home AS >> c_phone_home, >> c.phone_cell AS >> c_phone_cell, >> c.phone_work AS >> c_phone_work, >> c.email AS c_email, >> c.other_contacts >> AS c_other_contacts, >> count(*) as apt_qty >> >> FROM tl_appt apt >> >> JOIN tl_clients c >> on c.client_id = apt.client_id >> JOIN tl_rooms r on >> r.room_id = apt.room_id >> JOIN tl_users u on >> u.user_id = apt.user_id >> >> WHERE >> >> >> apt.time_start between '".$sd."' and '".$ed."' >> >> ".$where_sql." >> >> GROUP BY >> u.user_id, c.client_id >> having count(*) >> ".$aoper." ".$aqty." >> >> ORDER BY >> u.first_name, u.last_name, c.last_name, c.first_name >> INTO OUTFILE >> '/tmp/".$csv_file.".csv' >> FIELDS TERMINATED >> BY ',' >> ENCLOSED BY '\"'; >> LINES TERMINATED >> BY '"."\\n"."'"; >> >> echo $csv; >> >> >> >> $csv_query = $db->db_query($csv); >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> if you DO NOT specify a LINES TERMINATED BY command it defaults to \n > > > Good gracious ... note the extra ";" after ENCLOSED BY
