Hi. I would like to update the MySql Database but I have loads of fields and can not be bothered to rewrite it all. Is it possible to use the layout I have so far to update the database?
Here it the insert sql:
$sql = "INSERT INTO clients( cust_id, adate, a_f_name, a_s_name, a_occupation, b_f_name, b_s_name, b_occupation, house_no, address1, address2, postcode, home_tel, work_tel,
mob_tel, emailadd, contact_time, dov_from, dov_to, pv_from, pv_to, loc_from, loc_to, max_cost, mortgage, t_nd, t_resale,
t_apt, t_th, t_villa, t_finca, t_open, comp_date, beds, baths, built, plot, community, e_golf, e_coastside, e_ms, e_views, e_pool, uses, notes, a_doc, b_doc, c_doc, a_text, b_text, c_text, a_nc, b_nc, c_nc, sourse, staff_id, nation )
VALUES
('$f_cust_id', '$f_adate', '$f_a_f_name', '$f_a_s_name', '$f_a_occupation', '$f_b_f_name', '$f_b_s_name', '$f_b_occupation',
'$f_house_no', '$f_address1', '$f_address 2', '$f_postcode', '$f_home_tel', '$f_work_tel', '$f_mob_tel', '$f_emailadd', '$f_contact_time', '$f_dov_from', '$f_dov_to', '$f_pv_from', '$f_pv_to', '$f_loc_from', '$f_loc_to', '$f_max_cost', '$f_mortgage', '$f_t_nd',
'$f_t_resale', '$f_t_apt', '$f_t_th', '$f_t_villa', '$f_t_finca', '$f_t_open', '$f_comp_date', '$f_beds', '$f_baths', '$f_built', '$f_plot', '$f_community', '$f_e_golf', '$f_e_coastside', '$f_e_ms', '$f_e_views', '$
f_e_pool', '$f_uses', '$f_notes', '$f_a_doc', '$f_b_doc', '$f_c_doc', '$f_a_text', '$f_b_text', '$f_c_text', '$f_a_nc', '$f_b_nc', '$f_c_nc', '$f_sourse', '$f_staff_id', '$f_nation');
lol told you it was long 😃
Thanks in advance
