
I want that if the user clicks the save button, all text field which is not empty will be stored into the database. Otherwise, if it is empty, it will be ignored.
here are the names of the text fields in order.
legend: quantity =qty ; amt = amount
qty1 dropdown1 price1 amt1
qty2 dropdown2 price2 amt2
qty3 dropdown3 price3 amt3
qty4 dropdown4 price4 amt4
qty5 dropdown5 price5 amt5
values will be save in database table named "tbl_sales"
I really don't know how to deal with this, should i use "array"? or just "IF". Any helping hand?
Thanks a lot in advance.