title: multiple mysql queries in php
body: <p>I am trying to get a specific square in a mysql table. Here is what I have so far.</p>
  
  <pre><code>$sql = "select Saturdaymorning From schedule where username like '%$user%';";
  $stmt = $db-&gt;prepare("select Saturdaymorning From schedule where username like '%$user%';");
  $stmt = $db-&gt;exec($sql)
  
  $sql1 = "select Saturdayafternoon From schedule where username like '%$user%';";
  $stmt1 = $db-&gt;prepare("select Saturdayafternoon From schedule where username like '%$user%';");
  $stmt1 = $db-&gt;exec($sql1)
  </code></pre>
  
  <p>I am able to get the first one to work but the second gets a buffer error. How could one run multiple queries at once. I do not understand the "fetchall()" command or how it works. Thanks</p>
  
  <p>[EDIT] I have to call them apart because I use them in if statements akin to</p>
  
  <pre><code>if($sql = "yes"){ satmorn = "Saturday Morning"} 
  </code></pre>
  
  <p>and so on.</p>