hi,
i am having probelm in inserting some form data inside mysql databse
the error is something like this
“Out of range value adjusted for column ‘ball_id’ at row 1”
the code i am using is like this
=======================FORM==============================
<form action=”bbiprocess.php” method=”post”>
<table align= “center” border=”1″ width=”54%”>
<tr>
<td width=”59%”>Ball Id</td>
<td width=”41%”> <input type=text name=ball_id</td>
</tr>
<tr>
<td width=”59%”>Ball Manufacturer</td>
<td width=”41%”> <input type=text name=ball_mnfr</td>
</tr>
<tr>
<td width=”59%”>Ball Name</td>
<td width=”41%”> <input type=text name=ball_name</td>
</tr>
</table> <br>
<center> <input type=submit value=”Submit” >
</form>
=========================================================
and the processing part is
=================PROCESSING PAGE===========================
include “connection.php”;
$ball_id = $_POST[‘ball_id’];
$ball_manufacturer = $_POST[‘ball_mnfr’];
$ball_name = $_POST[‘ball_name’];
$qry = “INSERT INTO ball values (‘$ball_id’,’$ball_manufacturer’,’$ball_name’)”;
$res = mysql_query($qry);
print(mysql_error());
if($res)
{ echo “<br><br><br><br><center>Bowl Added.”;
echo “<br>”;
?> Add Another Bowl <a href =”bbi_details.php”>Click Here</a></center>
<?
}
else
echo “Problem”;
==========================================================