This code has the following error--> Column count doesn't match value count at row 1

[gurinder16]

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
/*
// Create database

if (mysql_query("CREATE DATABASE admin",$con))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }
*/

/*
 CREATE TABLE `admin`.`payment_invoice` (
`CompanyName` VARCHAR( 100 ) NOT NULL ,
`InvoiceNo.` INT( 5 ) NOT NULL ,
`Address` VARCHAR( 100 ) NOT NULL ,
`InvoiceDate` DATE NOT NULL ,
`Item` VARCHAR( 100 ) NOT NULL ,
`Description` VARCHAR( 20 ) NOT NULL ,
`Rate` INT( 20 ) NOT NULL ,
`Qty` VARCHAR( 100 ) NOT NULL ,
`Unit` INT( 20 ) NOT NULL ,
`Price` INT( 20 ) NOT NULL ,
`Amount` INT( 20 ) NOT NULL ,
`ServiceTaxRegNo` INT( 20 ) NOT NULL ,
`AmountTotal` INT( 20 ) NOT NULL ,
`PanNo.` INT( 20 ) NOT NULL ,
`ServiceTax` INT( 20 ) NOT NULL ,
`CategoryOfServices` VARCHAR( 100 ) NOT NULL ,
`EducationCess` INT( 20 ) NOT NULL ,
`SecondaryEducationCess` INT( 20 ) NOT NULL,
`ShareOfClame` INT( 20 ) NOT NULL ,
`TotalValue` VARCHAR( 100 ) NOT NULL ,
`InInteger` INT( 10 ) NOT NULL ,
`CheckedBy` VARCHAR( 100 ) NOT NULL ,
`VerifiedBy` VARCHAR( 100 ) NOT NULL ,
`ForBusinessPartner` VARCHAR( 100 ) NOT NULL ,
`ApprovedBy` VARCHAR( 100 ) NOT NULL ,
`AuthorisedSignatory` VARCHAR( 100 ) NOT NULL
) ENGINE = InnoDB 

*/



mysql_query($sql,$con);

mysql_select_db("admin", $con);

 $sql = "INSERT INTO `payment_invoice` (`CompanyName`, `InvoiceNo.`, `Address`, `InvoiceDate`, `Item`, `Description`, `Rate`, `Qty`, `Unit`, `Price`, `Amount`, `ServiceTaxRegNo`, `AmountTotal`, `PanNo.`, `ServiceTax`, `CategoryOfServices`, `EducationCess`, `SecondaryEducationCess`, `ShareOfClame`, `TotalValue`, `InInteger`, `CheckedBy`, `VerifiedBy`, `ForBusinessPartner`, `ApprovedBy`, `AuthorisedSignatory`) VALUES ('$_POST[fname4]','$_POST[fname422]','$_POST[comments]','$_POST[fname42]','$_POST[fname423]','$_POST[fname424]','$_POST[fname425]','$_POST[fname426]','$_POST[fname427]','$_POST[fname428]','$_POST[fname4282]''$_POST[fname43]','$_POST[fname47]''$_POST[fname44]','$_POST[fname48]','$_POST[fname45]','$_POST[fname49]','$_POST[fname410]','$_POST[fname452]','$_POST[fname4102]','$_POST[fname41025]','$_POST[fname41022]''$_POST[fname41023]''$_POST[fname41024]','$_POST[fname410232]','$_POST[fname410252]')";





if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Congrats! You hav Sucessfully Submitted your information";


$result = mysql_query("SELECT * FROM payment_invoice");

echo "<table border='1'>
<tr>
<th>CompanyName</th>
<th>InvoiceNo</th>
<th>Address</th>
<th>InvoiceDate</th>
<th>Item</th>
<th>Description</th>
<th>Rate</th>
<th>Qty</th>
<th>unit</th>
<th>Price</th>
<th>Amount</th>
<th>ServiceTaxRegNo</th>
<th>AmountTotal</th>
<th>PanNo.</th>
<th>ServiceTax</th>
<th>CategoryOfServices</th>
<th>EducationCess</th>
<th>SecondaryEducationCess</th>
<th>ShareOfClame</th>
<th>TotalValue</th>
<th>InInteger</th>
<th>CheckedBy</th>
<th>VerifiedBy</th>
<th>ForBusinessPartner</th>
<th>ApprovedBy</th>
<th>AuthorisedSignatory</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['CompanyName'] . "</td>";
  echo "<td>" . $row['InvoiceNo'] . "</td>";
  echo "<td>" . $row['Address'] . "</td>";
  echo "<td>" . $row['InvoiceDate'] . "</td>";
  echo "<td>" . $row['Item'] . "</td>";
  echo "<td>" . $row['Description'] . "</td>";
  echo "<td>" . $row['Rate'] . "</td>";
  echo "<td>" . $row['Qty'] . "</td>";
  echo "<td>" . $row['unit'] . "</td>";
  echo "<td>" . $row['Price'] . "</td>";
  echo "<td>" . $row['Amount'] . "</td>";
  echo "<td>" . $row['ServiceTaxRegNo'] . "</td>";
  echo "<td>" . $row['AmountTotal'] . "</td>";
  echo "<td>" . $row['PanNo.'] . "</td>";
  echo "<td>" . $row['ServiceTax'] . "</td>";
  echo "<td>" . $row['CategoryOfServices'] . "</td>";
  echo "<td>" . $row['EducationCess'] . "</td>";
  echo "<td>" . $row['SecondaryEducationCess'] . "</td>";
  echo "<td>" . $row['ShareOfClame'] . "</td>";
  echo "<td>" . $row['TotalValue'] . "</td>";
  echo "<td>" . $row['InInteger'] . "</td>";
  echo "<td>" . $row['CheckedBy'] . "</td>";
  echo "<td>" . $row['VerifiedBy'] . "</td>";
  echo "<td>" . $row['ForBusinessPartner'] . "</td>";
  echo "<td>" . $row['ApprovedBy'] . "</td>";
  echo "<td>" . $row['AuthorisedSignatory'] . "</td>";
    echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>

[darkagn]

Hi gurinder16 and welcome to DaniWeb :)

Looks to me like you are missing one or more commas in the values section of your query. Count your columns, then count the items you are inserting - these need to be equal as your error message implies.

[almostbob]

have you tried it without the dot in invoicNo

thinks concatenation

[Will Gresham]

darkagn is correct, looks like you are missing multiple commas in the values of the query.

Also, may I suggest that you sanitize the input from the form.. Entering unchecked POST data into your database is asking for trouble.

darkagn is correct, looks like you are missing multiple commas in the values of the query.

Also, may I suggest that you sanitize the input from the form.. Entering unchecked POST data into your database is asking for trouble.

Asking? Positively inviting! Mwahahaahaaa.