title: Inserting an email address into a table field
body: <pre><code>// write student record
  $query = "INSERT INTO Student (SLastName, SFirstName, SeMail, SGrade, SPhone, SCell, SLunch)".
  " VALUES ($LastName, $FirstName, $email, $grade, $phone, $cell, $lunch)";
  echo $query . '&lt;br /&gt;';
  $result = mysql_query($query);
  if (!$result)
       die("Error inserting Student record: ". mysql_error());
  </code></pre>
  
  <hr>
  
  <pre><code>INSERT INTO Student (SLastName, SFirstName, SeMail, SGrade, SPhone, SCell, SLunch)
  VALUES (Weiner, Wendy, somemail@gmail.com, 12, 2123334444, 8458765555, 5)
  </code></pre>
  
  <hr>
  
  <blockquote>
    <p>Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com, 12, 2123334444, 8458765555, 5)' at line 1</p>
  </blockquote>
  
  <p>Server version: 5.0.91-community</p>