Updated 2 values in 1 column with SQL
<p>This is probably super easy but I am not sure how to word it for search purposes. I have a table that goes something likes this:</p>

<pre><code>id   month   current
1    may     0
2    june    0
3    july    1
</code></pre>

<p>Current is set to be a boolean. 1 indicated that it's current. 0s show that it's not and won't be used in code for display purposes. Either way, how can I write an UPDATE sql query to simultaneously set July to "0" and change may to "1" if May is selected? So far I've "concocted" this awfulness:</p>

<pre><code>if(isset($_POST["setMonth"])){
   $month = $_POST["monthname"];  // Storing Selected Value In Variable
   $query_set_month = "UPDATE months SET current = 0 WHERE month = $current_month AND current = 1"; //this will "unset" my current month...?
   $result_month = mysql_query($query_set_month) or die('Query failed: ' .
                    mysql_error() . "&lt;br /&gt;\n$sql");
}
</code></pre>