/    Sign up×
Community /Pin to ProfileBookmark

Out of range value adjusted for column ‘ball_id’ at row 1

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%”>&nbsp;<input type=text name=ball_id</td>
</tr>
<tr>
<td width=”59%”>Ball Manufacturer</td>
<td width=”41%”>&nbsp;<input type=text name=ball_mnfr</td>
</tr>
<tr>
<td width=”59%”>Ball Name</td>
<td width=”41%”>&nbsp;<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”;

==========================================================

to post a comment
PHP

0Be the first to comment 😎

×

Success!

Help @ashishrathore spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.18,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...