It means you are trying to insert 22 values into 20 fields
-----Original Message-----
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 4:11 PM
To: PHP developers
Subject: [PHP] can anyone explain this error ?
I am doing an insert into a EMPTY mysql table.
1 field is an auto increment.
here is the error I get when I do the insert
"Column count doesn't match value count at row 1"
What does this mean ?
Here is the php used to insert it.
<?php
include("../dbconnect.php");
if ($submit == "sign!")
{
$query = "insert into account_details
(account_number, account_type, account_name,
account_address, account_addres1, account_address2, account_address3,
account_address4, account_address5, account_contact, account_phone,
account_fax, account_email, account_start_date, account_authorised_credit,
account_pin, account_disabled_flag, metered_jobs, unmetered_jobs,
account_pin_activate) values
('$account_number', '$account_type', '$account_name', '$account_house',
'$account_street', '$account_street1', '$account_street2', '$account_town',
'$account_city', '$account_postcode', '$account_country',
'$account_contact', '$account_phone', '$account_fax', '$account_email',
'$account_start', '$account_credit_authorised', '$account_pin',
'$account_disabled_flag', '$metered_job_count', '$unmetered_job_count',
'$account_pin_activated')";
mysql_query($query) or
die (mysql_error());
?>
<H2> Data Submitted </H2>
<H2> <A HREF="view_test_records.php"> View the records </A></H2>
<?php
}
else
{
include("datafillcommit.php");
}
?>
~
Thanks,
Matt.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
