title: Multiple queries in one SQL statement using PHP
body: <p>I'm trying to execute a delete statement on multiple tables in my db but for some reason this code isn't working and I'm not sure why. $productId is passed over using a $_GET variable. This statement works in phpMyAdmin but when I get it into my site it stops working. Is the syntax wrong?</p>
  
  <pre><code>$sql = '
      DELETE FROM products
      WHERE prod_id = ' . $productID . '
      LIMIT 1;
  
      DELETE FROM product_category
      WHERE prod_id = ' . $productID . '
      LIMIT 3;
  
      DELETE FROM product_images
      WHERE prod_id = ' . $productID .'
      LIMIT 1
  ';
  
  $db-&gt;query($sql);
  </code></pre>