mysql insert statement with data in certain fields
Posted on 2003-11-28
Ok, now I have:
mysql_query("INSERT INTO user VALUES ('$cust_data','$cust_data','$cust_data','$cust_data','$cust_data','$cust_data')");
Which inserts data into a table with six fields.
However.... I have more than six fields in this table, so I get an error. Each month the table will grow by one field.
How can I change this so that the data will go into the first six fields of the table, and leave the remaining fields (however many there are) empty (data to be added later), without an error?
If needed, the names of the first six fields are: number, brand, account, order date, name, status.
Thanks for any assistance you can provide. This is the last question for this project, once I have this it will all work!