title: Executing Multiple MSSQL Queries with PHP at once
body: <p>I am having trouble with executing numerous ms_sql queries at once in PHP:</p>
  
  <p>Below is a simplified version of what I am trying to do:</p>
  
  <pre><code>$updatesql = "UPDATE Pricing SET Price = '".$_POST['price1']."' WHERE PriceID = 1 ";
  $updatesql = "UPDATE Pricing SET Price = '".$_POST['price2']."' WHERE PriceID = 2 ";
  $updatesql = "UPDATE Pricing SET Price = '".$_POST['price3']."' WHERE PriceID = 3 ";
  $updatesql = "UPDATE Pricing SET Price = '".$_POST['price4']."' WHERE PriceID = 4 ";
  $updatesql = "UPDATE Pricing SET Price = '".$_POST['price5']."' WHERE PriceID = 5 ";
  $updatesql = "UPDATE Pricing SET Price = '".$_POST['price6']."' WHERE PriceID = 6 ";
  $updatesql = "UPDATE Pricing SET Price = '".$_POST['price7']."' WHERE PriceID = 7 ";
  $updatesql = "UPDATE Pricing SET Price = '".$_POST['price8']."' WHERE PriceID = 8 ";
  
  $executesql = mssql_query($updatesql);
  </code></pre>
  
  <p>When I go through them one by one they all work, however when I try to execute them all at once, only the <strong>LAST</strong> query seems to get executed. </p>
  
  <p>Is what I'm trying to do possible? Any pointers where Im going wrong? Sorry fairly new to PHP. </p>