MYSQL error: column count doesn't match vakue count at row

[mark103]

Hi guys,

I need your help. I am trying to insert the rows in the mysql database as I input the values in the url bar which it would be like this:

www.mysite.com/testupdate.php?user=tester&pass=test&user1=tester&email=me@****mail.com&ip=myisp

However i have got a error which i don't know how to fix it.

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

<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbusername');
    define('DB_PASSWORD', 'mydbpassword');
    define('DB_DATABASE', 'mydbname');

$errmsg_arr = array();
    $errflag = false;

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {

die('Failed to connect to server: ' . mysql_error());
    }

$db = mysql_select_db(DB_DATABASE);
if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    $adduser = clean($_GET['user1']);
    $email = clean($_GET['email']);
    $IP = clean($_GET['ip']);
    if($username == '') {
  $errmsg_arr[] = 'username is missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD is missing';
  $errflag = true;
    }
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
   $sql = "INSERT INTO `members` (`username`,`email`,`IP`) VALUES ('$adduser','$email','$IP')";

if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }
echo "The information have been updated.";
  }
?>

Here's the name of the columns i have got in my database:

username
email
IP

I have input the correct columns names, so I can't correct the problem I am getting.

Please can you help?

[bradgrafelman]

Inside your if() statement that checks if a SQL error occurred, output the SQL query string itself as well and paste it here for us to see.

[mark103]

ok do you need me to update my code something like this:

  die('<br>Error: ' . mysql_error() . "<br>Query: $sql" );

And then post back with the sql query error?

[bradgrafelman]

Yes, that would work, although the error isn't what we're missing (you already posted that above, didn't you?) - it would also be beneficial to see the SQL query string.