<p>I display data into an html table, w/ a drop down box with a list of venues. Each volunteer will be assigned a venue. I envision being able to go down thru the html table and assigning each volunteer a venue. The drop down box contains all the possible venues that they can be assigned to.</p>

<pre><code>&lt;select&gt;
&lt;option value="1"&gt;Setup&lt;/option&gt;
&lt;option value="2"&gt;Check in&lt;/option&gt;
etc...
&lt;/select&gt;
</code></pre>

<p>Then once I am done assigning each volunteer, I want to hit submit and it will assign the appropriate value for each volunteer.</p>

<p>How would I go about doing that, I know how to do that, but only one at a time.</p>

I can't think of any way. You can put multiple SQL statements into 1 MySQL query:
```
```
UPDATE volunteer SET venue = 1 WHERE id = 2;
UPDATE volunteer SET venue = 2 WHERE id = 3;
...
```
```
I wish there was a way, but I'm thinking that the where will be too different in each query to make it into one.