title: Unable to delete entry from table where value contains a space in the middle?
body: <p>I'm able to delete the entries which have a single word like 'Tomato' or 'Potato'.
  Unable to delete entries with multiple words like 'pumpkin soup'.</p>
  
  <p>Why is that?</p>
  
  <p>Here's my PHP:</p>
  
  <pre><code>&lt;?php
                     if(!empty($_POST['event_name_box']))
                     {
                      $del_event=$_POST['event_name_box'];
                      $sth = $conn-&gt;prepare("DELETE FROM event WHERE event_name=:del");
                      $sth-&gt;execute(array(':del'=&gt;$del_event));
                      header( "Refresh: 0;" );
                     }
              ?&gt;
  </code></pre>
  
  <p>And this is how I'm loading the values in drop down:</p>
  
  <pre><code> &lt;select name="event_name_box" value="event_name_box" style="width:220px; padding-left:40px;font-size:18px;font-family:Roboto;"&gt;
              &lt;?php
              $sth = $conn-&gt;prepare('Select event_name From event');
              $sth-&gt;execute();
              $data = $sth-&gt;fetchAll();   
              foreach ($data as $row ){
                  if($row['event_name']!="")
              echo " &lt;option id=\"EventName\" name=\"EventName\" value=".$row['event_name']."&gt;".$row['event_name']."&lt;/option&gt;";
              }
              ?&gt; 
              &lt;/select&gt;&lt;br&gt;
              &lt;input type="submit" name="submit" style="width:50%;padding:10px" value="Delete"&lt;/input&gt;
  </code></pre>