<div>
<br />
Thank you !<br />
<br />
Chris
</div>


<div>
Arjanh should have helped you already. I would like to remind you all &quot;additional&quot; fields in the coming future must be nullable field. Otherwise, you would encounter error as non-nullable fields can't contain null values.
</div>


Arjanh should have helped you already. I would like to remind you all "additional" fields in the coming future must be nullable field. Otherwise, you would encounter error as non-nullable fields can't contain null values.

<div>
<br />
Thank you Arjanh, they are :)<br />
<br />
Chris
</div>


<div>
<br />
oopps, I mean Thank you Hardaway of course -
</div>



oopps, I mean Thank you Hardaway of course -

<div>
<div class="content wysiwyg-content">
<br />
Ok, now I have:<br />
<br />
mysql_query(&quot;INSERT INTO user VALUES ('$cust_data[0]','$cust_da<wbr />ta[1]','$c<wbr />ust_data[2<wbr />]','$cust_<wbr />data[3]','<wbr />$cust_data<wbr />[4]','$cus<wbr />t_data[5]'<wbr />)&quot;);<br />
<br />
Which inserts data into a table with six fields.<br />
<br />
However.... &nbsp;I have more than six fields in this table, so I get an error. &nbsp;Each month the table will grow by one field.<br />
<br />
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?<br />
<br />
If needed, the names of the first six fields are: number, brand, account, order date, name, status.<br />
<br />
Thanks for any assistance you can provide. &nbsp;This is the last question for this project, once I have this it will all work!<br />
<br />
Chris<br />
<br />
<br />
<br />

</div>
</div>



Ok, now I have:

mysql_query("INSERT INTO user VALUES ('$cust_data[0]','$cust_data[1]','$cust_data[2]','$cust_data[3]','$cust_data[4]','$cust_data[5]')");

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!

Chris





mysql insert statement with data in certain fields

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.