<?xml version="1.0" encoding="windows-1252"?>
<node id="991336" title="Re: input form and MySQL across columns" created="2012-09-02 18:59:16" updated="2012-09-02 18:59:16">
<type id="11">
note</type>
<author id="989386">
philiprbrenan</author>
<data>
<field name="doctext">
&lt;p&gt;If you name the input fields like this using a character say - that you know will not occur in your item names:&lt;/p&gt;
&lt;code&gt;
&lt;input name="Shoes-1" size=2&gt;
&lt;input name="Shoes-2" size=2&gt;
&lt;input name="Shoes-3" size=2&gt;
&lt;input name="Shoes-4" size=2&gt;
&lt;input name="Shoes-5" size=2&gt;
&lt;/code&gt;
&lt;p&gt;and likewise Tires etc. then it will be easy for you to 
test whether the form has sent you back "Shoes-2" etc. and if it has, you can use a SQL Update statement to modify just the one column in one row:&lt;/p&gt;
&lt;code&gt;
update ... set qty2 = ... where name = "Shoes";
&lt;/code&gt; </field>
<field name="root_node">
991331</field>
<field name="parent_node">
991331</field>
</data>
</node>
