mysql integer problem
<p>i am using following code to add data into mysql database</p>

<pre><code>&lt;?php
$debdes  = $_POST['debdes'];
$debamt  = $_POST['debamt'];
$crdes   = $_POST['crdes'];
$cramt   = $_POST['cramt'];
$date    = $_POST['date'];
$cberror = "&lt;h1&gt;Data not Added&lt;/h1&gt;&lt;br/&gt;&lt;br/&gt;&lt;h3&gt;Please Follow The Instructions&lt;/h3&gt;";

include_once ("db.php");



if (empty ($date)) die ("$cberror");

if (empty ($debamt) &amp;&amp; empty ($debdes) &amp;&amp; empty ($cramt) &amp;&amp; empty ($cramt)) die ("$cberror");

if (!empty($debamt) &amp;&amp; empty ($debdes))die ("$cberror");

if (!empty($debdes) &amp;&amp; empty ($debamt)) die ("$cberror");


if (!empty($cramt) &amp;&amp; empty ($crdes)) die ("$cberror");

if (!empty($crdes) &amp;&amp; empty ($cramt)) die ("$cberror");

 $ucbook = "INSERT INTO cbook(debdes,debamt,crdes,cramt,date) VALUES ('$debdes','$debamt','$crdes','$cramt','$date');";

if(mysql_query("$ucbook"))

{
echo "&lt;h3&gt;One Record Updated Successfully with the following Details &lt;/h3&gt;&lt;br/&gt;";
echo "Date = $date &lt;br/&gt;&lt;br/&gt;";
echo "Debt Amount =$debamt &lt;br/&gt;&lt;br/&gt;";
echo "Debt Description = $debdes &lt;br/&gt;&lt;br/&gt;";
echo "Credit Amount = $cramt &lt;br/&gt;&lt;br/&gt;";
echo "Credit Description = $crdes &lt;br/&gt;&lt;br/&gt;";

}
else 
{
echo "&lt;be/&gt;&lt;br/&gt;The Following Error Occure While Updatig Data&lt;br/&gt;&lt;br/&gt;";
echo mysql_error(); 
}

?&gt;
</code></pre>

<p>now the problem is that as i set the value of "debamt" as integer in mysql then error comes</p>

<pre><code>Incorrect integer value: '' for column 'debamt' at row 1 
</code></pre>

<p>although i did not insert value in "debamt" i am also filling other data correctly</p>

<p>??????</p>
