This is the echo of my query
insert into mobile_table(mobile_date,waranty,invoice_no,make,model,imei,accessories,other_acc,faults,other_info,unique_id,customer_name,customer_address1,customer_address2,customer_contact_code,customer_contact,email,mode,payment_total) values('2010/04/28','No Warranty',,'LG','5421','12345678','1. Charge Stand ','no','1. Water damage
the form doesnt gets submits.
if the query is echoing the value of invoice_no as blank and in the database if the field is set as null, the form should get submit.
if i insert the above through sql in databse directly then this error comes
#1064 - 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 ''LG','5421','12345678','1. Charge Stand ','no','1. Water damage
','','015e' at line 1
if i manaully write invoice_no and again submit the query then the error is gone