lazysheepmedia
Member
Folks
When I edit a record and the page returns to the list, I get this sql error
Any ideas?
Thanks
When I edit a record and the page returns to the list, I get this sql error
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 '' at line 1 SQL=UPDATE `tenants_reg` SET `ten_reg_name`='Mark Smith',`ten_reg_id_name`='NH676543T',`ten_email`='demo@demo.com.uk',`ten_reg_dob`='1966-08-12',`ten_contact_num`='01234567890',`ten_children`='0',`How_Did_The_Tenant_Perform`='good',`ten_pets`='0',`tenants_user_id`='286',`tenants_employed_yesno`='0',`tenants_pets_emergency_contact`='0',`tenant_emp_employer`='',`tenants_emp_contactName`='',`tenants_emp_number`='',`tenants_pets_vet_name`='',`tenants_pets_vet_number`='' WHERE
Any ideas?
Thanks