title: How to merge two UPDATE queries into one, different WHERE and SET?
body: <p>I was wondering if it's possible to combine these two queries as they do not work separately (one of the two only works). They are</p>
  
  <pre><code>$addquery = "UPDATE winners SET mem_name='$addname' WHERE mem_name='$deletename'";
  $addresult= mysqli_query($connect, $addquery);
  $query = "UPDATE winners INNER JOIN members SET winners.mem_id = members.mem_id
                      WHERE winners.mem_name = members.mem_name";
  $result = mysqli_query($connect, $query);
  </code></pre>
  
  <p>Can this be done in just one query? Thank you!!!</p>