website help :/

[pandazin]

Help me with this error please

REGISTER.PHP:
<?php
// By SdfSdf
ob_start();
session_start();
?>
<?php include "inc/bysdfsdf_config.php";?>
<script type="text/javascript" language="javascript">
function kontrol()
{
var kadi = document.getElementById('kadi').value;
var pass = document.getElementById('pass').value;
var pass2 = document.getElementById('pass2').value;

if(kadi == '')
{
alert('Write your username!');
return false;
}
else if(pass == '')
{
alert('Write your password!');
return false;
}
else if(pass2 == '')
{
alert('Repeat your password!');
return false;
}
else
{
document.register.submit();
}
}
</script>
<?php
include "inc/bysdfsdf_config.php";


if ($_POST) {


############### By SdfSdf #########
$account = $_POST['kadi']; ######
$pass = $_POST['pass']; ######
$pass2 = $_POST['pass2']; ######
$eposta = $_POST['eposta']; ######
$eposta2 = $_POST['eposta2'];######
$userage = $_POST['userage'];######
$usertype = 1; ######
$loginflag = 0; ######
###################################


$veriss = odbc_exec($conn,"select Count(*) from MB_USR where user_id = '".$account."'");
$varmis = odbc_result($veriss,1);
if ($varmis) {
ECHO "THIS USER NAME AVAILABLE";
}
else {


$msquerys="INSERT INTO MB_USR (user_id,user_pwd,user_type,login_flag,user_age,user_email,gsoru,gyanit) VALUES ('".$account."','".$pass."','".$usertype."','".$loginflag."','".$userage."','".$eposta."')";
$msresultss=odbc_exec($conn,$msquerys) or die('error');


echo '<div align="center">
<p align="center"><strong>#################### Congratulations ! ####################</strong></p>
<p align="center"><strong>User registration is completed successfully.</strong></p>
<p align="center"><font size="3" face="Arial" color="red"><b>Username:</b> '.$account.'</p>
<p align="center"><font size="3" face="Arial" color="red"><strong>Coder: By SdfSdf </strong></p>
<p> </p>-
</div>
';
}
}
else{
echo '
<div align="center">
<img src="http://forum.ragezone.com/images/memberust.png" border="0">
<BR><BR>
<form action="" method="post" name="register" id="register" onsubmit="">
<table border="0">
<tr>
<td align="center"><font size="2" face="Arial" color="red"><b>Username:</b></td>
<td><center><input type="text" id="kadi" name="kadi" title="Username" maxlength="12" /></center></td>
</tr>
<tr>
<td align="center"><font size="2" face="Arial" color="red"><b>Password:</b></td>
<td><center><input type="password" id="pass" name="pass" title="Password" maxlength="15" /></center></td>
</tr>
<tr>
<td align="center"><font size="2" face="Arial" color="red"><b>Re-Password:</b></span></td>
<td><center><input type="password" id="pass2" name="pass2" title="Re-Password" maxlength="15" /></center></td>
</tr>
<tr>
<td align="center"><font size="2" face="Arial" color="red"><b>Email:</b></td>
<td><center><input type="text" name="eposta" title="Email" maxlength="20" /></center></td>
</tr>
<tr>
<td align="center"><font size="2" face="Arial" color="red"><b>Re-Email:</b></span></td>
<td><center><input type="text" name="eposta2" title="Re-Email" maxlength="20" /></center></td>
</tr>
<tr>
<td align="center"><font size="2" face="Arial" color="red"><b>Age:</b></td>
<td><center><input type="text" name="userage" title="age" maxlength="20" /></center></td>
</tr>
<td align="center"> </td>
<td><center><font size="4" face="Arial" color="BLUE"><input type="submit" onclick="kontrol();" name="button" id="button" value="Create-Account" /></center></td>
</tr>
</table>
</form>
</div>';}
?>

 

[majortom1]

the insert function have more data than your values defined above , you defined 3 values and you want to insert 8 !