Error: Column count doesn't match value count at row 1

billshackle · March 17, 2006

I have the following error: Column count doesn't match value count at row 1

with this script. i can't seem to find anything obvious in my script that causes this - if anyone could shed light. Would appreciate it.

Script:

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

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

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

        $vid = $_POST['vid'];
        $name = $_POST['name'];
        $uid = $_POST['uid'];
        $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` , `uid` , `name` , `q1` , `q2` , `q3` , `q4` , `q5` , `comments` , `q6` )";

        mysql_query($query) or die (mysql_error());
}
?>
      <form action="rating.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="uid" name="uid" value="<? echo $id; ?>">
    <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]

Prismatic · March 17, 2006

Change:

[code]$query = "INSERT INTO `survey` ( `vid` , `uid` , `name` , `q1` , `q2` , `q3` , `q4` , `q5` , `comments` , `q6` )";[/code]

To:

[code]$query = "INSERT INTO survey ('vid' , 'uid' , 'name' , 'q1' , 'q2' , 'q3' , 'q4' , 'q5' , 'comments' , 'q6') VALUES ('$vid', '$name', '$uid', '$q1', '$q2', '$q3', '$q4', '$q5', '$comments', '$q6')";[/code]

Sign In

Error: Column count doesn't match value count at row 1

Recommended Posts

billshackle

Link to comment

Share on other sites

Prismatic

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information