PHP - Character Count

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:

Code: [Select]
www.mysite.com/testupdate.php?user=tester&pass=test&user1=tester&email=me@shitmail.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:

Code: [Select]
username
email
IP


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

Please can you help?

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=331562.0

Why am I getting this error when there are 3 Fields with 3 values?

Column count doesn't match value count at row 1

Code: [Select]
$sql5="INSERT INTO participants (participant_name, team_no, sport)
VALUES ('".implode("','$_POST[team]'),('",$_POST['participant_name'])."','$_POST[team]','$sport')";

Anyone can help me?

<?php
$tbl_name="menu";
$kategorije = mysql_query("SELECT * FROM $tbl_name WHERE Left(menu_name, 1) BETWEEN 'A' AND 'M' ORDER BY menu_name ASC");
if (!$kategorije) {
die("Database query failed: " . mysql_error());
}

while ($row=mysql_fetch_array( $kategorije )) {
echo "<div id=lista-header><h4>{$row["menu_name"]}</h4></div>";
$id_sub=$row['id_menu'];
$podkategorije = mysql_query("SELECT * FROM submenu WHERE id_menu=$id_sub ORDER BY sub_name ASC", $connection);
if (!$podkategorije) {
die("Database query failed: " . mysql_error());
}
echo "<ul class=\"pod\">";
while ($pod=mysql_fetch_array( $podkategorije )) {
echo "<li><a href=index.php?=podkate?".$pod["id_sub"]." class=black>{$pod["sub_name"]}</a><hr size=1 align=left width=100px color=#cccccc></li>";
}
echo "</ul>";
}


?>

In this way, I get list with categories and hes subcategories. How to count how many subcategories have each categories, and count how many articles have each categories?

Example (I wanna get this kind of look):

Categories name (3)
subcategoriesname (2)
subcategoriesname (4)
subcategoriesname (7)

Categories name (5)
subcategoriesname (1)
subcategoriesname (14)
subcategoriesname (9)
subcategoriesname (2)
subcategoriesname (


Categories name (2)
subcategoriesname (28)
subcategoriesname (17)

Where the numbers represent how many categories and sub-items have articles