how to Update value of 4 text box in mysql
<p>table structure:</p>

<pre><code>example(
id INT NOT NULL AUTO_INCREMENT, 
name VARCHAR(30), 
name_id INT)
</code></pre>

<p>I have 4 text boxes and fetch value display in this text boxes but in these text boxes there is a condition like this: </p>

<ol>
<li>all 4 text boxes are empty</li>
<li>one text box is filled with fetch value and 3 boxes are empty</li>
<li>two text boxes are filled with fetch values and 2 boxes are empty</li>
<li>three text boxes are filled with fetch value and 1 box is empty</li>
<li>all text boxes are filled with fetch values</li>
</ol>

<p>so how i update this scenario?</p>
