---
title: "Column count doesn't match value count at row 1"
type: "forum-thread"
url: "https://www.webforum.nu/amne/php/164463-column-count-doesn-t-match-value-count-at-row-1"
topic: "PHP"
topic_url: "https://www.webforum.nu/amne/php"
author: "Guldstrand"
published: "2007-09-12T19:42:03.000Z"
updated: "2007-09-12T19:46:22.000Z"
replies: 2
views: 288
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/php/164463-column-count-doesn-t-match-value-count-at-row-1"
---

# Column count doesn't match value count at row 1

## #1 — Guldstrand, 2007-09-12T19:42Z

```php
SQL Error
Column count doesn't match value count at row 1
in /*****/*****/makepoll.php, line 132
```

(Felet finns på rad **29** nedan.)

Någon som kan hjälpa mig att rätta till felet?    :r  

Här är koden:

```php
<?php 
// inkluderar databas m.m.

mysql_query("INSERT INTO polls VALUES(0" .
 ", '" . get_date_time() . "'" .
   ", " . sqlesc($question) .
   ", " . sqlesc($option0) .
   ", " . sqlesc($option1) .
   ", " . sqlesc($option2) .
   ", " . sqlesc($option3) .
   ", " . sqlesc($option4) .
   ", " . sqlesc($option5) .
   ", " . sqlesc($option6) .
   ", " . sqlesc($option7) .
   ", " . sqlesc($option8) .
   ", " . sqlesc($option9) .
  ", " . sqlesc($option10) .
 ", " . sqlesc($option11) .
 ", " . sqlesc($option12) .
 ", " . sqlesc($option13) .
 ", " . sqlesc($option14) .
 ", " . sqlesc($option15) .
 ", " . sqlesc($option16) .
 ", " . sqlesc($option17) .
 ", " . sqlesc($option18) .
 ", " . sqlesc($option19) . 
 ", " . sqlesc($sort) . 
")") or sqlerr(__FILE__, __LINE__);

$subject = sqlesc($question);

  mysql_query("INSERT INTO topics (userid, forumid, subject) VALUES(1, 6, $subject)") or sqlerr(__FILE__, __LINE__);

  //------ Insert post

  $added = "'" . get_date_time() . "'";

  $body = sqlesc($question);

  $topicid = mysql_insert_id() or stderr("Error", "No topic ID returned");

  mysql_query("INSERT INTO posts (topicid, userid, added, body) " .
  "VALUES($topicid, 1, $added, $body)") or sqlerr(__FILE__, __LINE__);

 if ($returnto == "main")
 header("Location: $BASEURL");
 elseif ($pollid)
 header("Location: $BASEURL/polls.php#$pollid");
else
 header("Location: $BASEURL");
die;
}

stdhead();

if ($pollid)
print("<h1>Ändra omröstning</h1>");
else
{
// Warn if current poll is less than 3 days old
$res = mysql_query("SELECT question,added FROM polls ORDER BY added DESC LIMIT 1") or sqlerr();
$arr = mysql_fetch_assoc($res);
if ($arr)
{
  $hours = floor((gmtime() - sql_timestamp_to_unix_timestamp($arr["added"])) / 3600);
  $days = floor($hours / 24);
  if ($days < 3)
  {
    $hours -= $days * 24;
    if ($days)
      $t = "$days dag" . ($days > 1 ? "ar" : "");
    else
      $t = "$hours timme" . ($hours > 1 ? "s" : "");
    print("<p><font color=red><b>Notera: Nuvarande omröstning (<i>" . format_comment($arr["question"]) . "</i>) är endast $t gammal.</b></font></p>");
  }
}
print("<h1>Skapa omröstning</h1>");
}
?>

<table border=1 cellspacing=0 cellpadding=5>
<form method=post action=makepoll.php>
<tr><td class=rowhead>Fråga <font color=red>*</font></td><td align=left><input name=question size=80 maxlength=255 value="<?=$poll['question']?>"></td></tr>
<tr><td class=rowhead>Alternativ 1 <font color=red>*</font></td><td align=left><input name=option0 size=80 maxlength=80 value="<?=$poll['option0']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 2 <font color=red>*</font></td><td align=left><input name=option1 size=80 maxlength=80 value="<?=$poll['option1']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 3</td><td align=left><input name=option2 size=80 maxlength=80 value="<?=$poll['option2']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 4</td><td align=left><input name=option3 size=80 maxlength=80 value="<?=$poll['option3']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 5</td><td align=left><input name=option4 size=80 maxlength=80 value="<?=$poll['option4']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 6</td><td align=left><input name=option5 size=80 maxlength=80 value="<?=$poll['option5']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 7</td><td align=left><input name=option6 size=80 maxlength=80 value="<?=$poll['option6']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 8</td><td align=left><input name=option7 size=80 maxlength=80 value="<?=$poll['option7']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 9</td><td align=left><input name=option8 size=80 maxlength=80 value="<?=$poll['option8']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 10</td><td align=left><input name=option9 size=80 maxlength=80 value="<?=$poll['option9']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 11</td><td align=left><input name=option10 size=80 maxlength=80 value="<?=$poll['option10']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 12</td><td align=left><input name=option11 size=80 maxlength=80 value="<?=$poll['option11']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 13</td><td align=left><input name=option12 size=80 maxlength=80 value="<?=$poll['option12']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 14</td><td align=left><input name=option13 size=80 maxlength=80 value="<?=$poll['option13']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 15</td><td align=left><input name=option14 size=80 maxlength=80 value="<?=$poll['option14']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 16</td><td align=left><input name=option15 size=80 maxlength=80 value="<?=$poll['option15']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 17</td><td align=left><input name=option16 size=80 maxlength=80 value="<?=$poll['option16']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 18</td><td align=left><input name=option17 size=80 maxlength=80 value="<?=$poll['option17']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 19</td><td align=left><input name=option18 size=80 maxlength=80 value="<?=$poll['option18']?>"><br></td></tr>
<tr><td class=rowhead>Alternativ 20</td><td align=left><input name=option19 size=80 maxlength=80 value="<?=$poll['option19']?>"><br></td></tr>
<tr><td class=rowhead>Sortera</td><td>
<input type=radio name=sort value=yes <?=$poll["sort"] != "no" ? " checked" : "" ?>>Ja
<input type=radio name=sort value=no <?=$poll["sort"] == "no" ? " checked" : "" ?>> Nej
</td></tr>
<tr><td colspan=2 align=center><input type=submit value=<?=$pollid?"'Ändra omröstning'":"'Skapa omröstning'"?> style='height: 20pt'></td></tr>
</table>
<p><font color=red>*</font> obligatoriskt</p>
<input type=hidden name=pollid value=<?=$poll["id"]?>>
<input type=hidden name=returnto value=<?=$_GET["returnto"]?>>
</form>
```

Permalänk: https://www.webforum.nu/p/164463

## #2 — Sjodahl, 2007-09-12T19:44Z

SKriv ut SQL frågan, så får vi se vad det står där.

Permalänk: https://www.webforum.nu/p/2027679

## #3 — Guldstrand, 2007-09-12T19:46Z

Såg att jag hade 20 alternativ i tabellen istället för 19.
Problemet är löst.

Permalänk: https://www.webforum.nu/p/2027680

---

Tråden på webben: https://www.webforum.nu/amne/php/164463-column-count-doesn-t-match-value-count-at-row-1