SQL Syntax Error

billshackle · April 19, 2006

I get the following error: [!--coloro:#3333FF--][span style=\"color:#3333FF\"][!--/coloro--]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 ''vid' , 'comname' , 'name' , 'q1' , 'q2' , 'q3' , 'q4' , 'q5' , 'comments' , 'q6' at line 1[!--colorc--][/span][!--/colorc--]

When executing this script;

If anyone could shed any light on this it would be appreciated.

Thanks in advance.

[code]
<? $username="";
$password="";
$database="test";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

if (isset($_POST['Submit'])) {

        $vid = $_POST['vid'];
        $comname = $_POST['comname'];
        $name = $_POST['name'];
        $q1 = $_POST['q1'];
        $q2 = $_POST['q2'];
        $q3 = $_POST['q3'];
        $q4 = $_POST['q4'];
        $q5 = $_POST['q5'];
        $comments = $_POST['comments'];
        $q6 = $_POST['q6'];

        $query = "INSERT INTO survey ('vid' , 'comname' , 'name' , 'q1' , 'q2' , 'q3' , 'q4' , 'q5' , 'comments' , 'q6')
        VALUES ('$vid', '$name', '$comname', '$q1', '$q2', '$q3', '$q4', '$q5', '$comments', '$q6')";

        mysql_query($query) or die (mysql_error());
}
?>
      <form action="reviews/rating8.php" method="post">
<body>
<table width="604" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="4">
  <tr>
    <td>Name:
      <br>
      <input name="name" type="text" />
      <br />
    <td>

    <td>UID:<br>
      <input type="comname" name="comname" value="<? echo $name; ?>">
    <td>
  <tr>    </tr><tr>
    <td colspan="4"></td>
  </tr>
  <tr>
    <td width="156">
    <select name="q1">
     <option value="1">1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
    </select></form></td>
    <td colspan="3"><label></label></td>
  </tr>
  <tr>
    <td colspan="4">What?</td>
  </tr>
  <tr>
    <td>
    <select name="q2">
     <option value="1">1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
    </select></form></td>
    <td width="118"> </td>
    <td width="316" colspan="2"> </td>
  </tr>
  <tr>
    <td colspan="4">What?</td>
  </tr>
  <tr>
    <td>
    <select name="q3">
       <option value="1">1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
    </select></form></td>
    <td> </td>
    <td colspan="2"> </td>
  </tr>
  <tr>
    <td colspan="4">What?</td>
  </tr>
  <tr>
    <td>

    <select name="q4">
      <option value="1">1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
    </select></form></td>
    <td> </td>
    <td colspan="2"> </td>
  </tr>
  <tr>
    <td colspan="4">What?</td>
  </tr>
  <tr>
    <td>
    <select name="q5">
      <option value="1">1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
    </select></form></td>
    <td> </td>
    <td colspan="2"> </td>
  </tr>
  <tr>
    <td colspan="4">Comments:</td>
  </tr>
  <tr>
    <td colspan="4">
      <textarea name="comments" cols="80" rows="4"></textarea>    </td>
  </tr>
  <tr>
    <td colspan="4">What?</td>
  </tr>
  <tr>
    <td>
    <select name="q6">
      <option value="1">1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
    </select><input name="Submit" type="Submit" />
    <p>
    </form></td>
    <td></td>
    <td colspan="2"> </td>
  </tr>
</table>
</p>
</body>
</html>[/code]

Barand · April 19, 2006

Don't put quotes round column names, only round values.

Sign In

SQL Syntax Error

Recommended Posts

billshackle

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information