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
// 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>