Jeg er ved at lave en kampdatabase, men der er noget galt... jeg får fejlen "Column count doesn't match value count at row 1"
koden ser sålesdes ud for nykamp.php
<?
include("../config.php");
if(isset($_POST[Are]))
{
$Page = $_POST[Page];
$Dato = $_POST[Dato];
$Saeson = $_POST[Saeson];
$Modstander = $_POST[Modstander];
$MalGSI = $_POST[MalGSI];
$MalModstander = $_POST[MalModstander];
$t = time();
$q1 = "INSERT INTO `Kampe` (`Page` , `Dato` , `Saeson` , `Modstander` , `MalGSI` , `MalModstander` ) VALUES ( '', '$Page', '$Dato', '$Saeson','$Modstander','$MalGSI','$MalModstander')";
mysql_query($q1) or die(mysql_error());
header("location:kampe.php");
}
else
{
include("header.php");
include("kampenav.php");
?>
<form name="form1" method="POST" enctype="multipart/form-data" action="nykamp.php">
<table border="0" width="600">
<tr>
<td width="252">Page:</td>
<td width="549">
<select size="1" name="Page">
<option value="1">Serie 3</option>
<option value="2">Serie 6</option>
<option value="3">Veteran</option>
<option value="4">U-10</option>
<option value="5">U-8</option>
<option value="6">U-7</option>
<option value="7">Stoppede spillere</option>
</select>
</td>
</tr>
<tr>
<td width="252">Dato:</td>
<td width="549"><input type="text" name="Dato" size="15" maxlength="50"></td>
</tr>
<tr>
<td width="252">Saeson:</td>
<td width="549"><input type="text" name="Season" size="15" maxlength="50"></td>
</tr>
<tr>
<td width="252">Modstander:</td>
<td width="549"><input type="text" name="Modstander" size="15" maxlength="50"></td>
</tr>
<tr>
<td width="252">MalGSI:</td>
<td width="549"><input type="text" name="MalGSI" size="15" maxlength="50"></td>
</tr>
<tr>
<td width="252">MalModstander:</td>
<td width="549"><input type="text" name="MalModstander" size="15" maxlength="50"></td>
</tr>
<tr>
<td width="252"> </td>
<td width="549"><input type="submit" value="Add Profiles" name="Are"></td>
</tr>
</table>
</form>
<?
include("footer.php");
}
?>
og kampenav.php
<?
echo'<br><br>
<table border="0" width="50%">
<tr>
<td width="33%"><a href="nykamp.php"><img border="0" src="images/addprofiles.jpg" width="121" height="26"></a></td>
<td width="33%"><a href="kampe.php"><img border="0" src="images/manageprofiles.jpg" width="132" height="26"></a></td>
</tr>
</table><br><br>';
?>