Incorrect integer value: '' for column error

Question

I am getting 'Incorrect integer value: '' for column country_id'. Sometimes my dropdown is hidden in the form. So I am not sure how to handle this situtation. Here is my code. Thanks for any help.

$countryId = isset($_POST['country']) ? $_POST['country'] : 0;

$inserSQL = "INSERT INTO Table1(country_id) VALUES('" .$countryId. "')";

$Result1 = mysql_query($inserSQL ) or die(mysql_error());

A little bit obvious but...where's the double or single quotes around the Sql statement? — Aurelio De Rosa
– Aurelio De Rosa, Commented Dec 8, 2011 at 18:27

Your Common Sense · Accepted Answer · 2011-12-08 18:43:09Z

6

You are adding ' to the $countryId value. Since an integer is expected, you don't have to use them. Try this:

$countryId = isset($_POST['country']) ? (int)$_POST['country'] : 0;

$inserSQL = "INSERT INTO Table1(country_id) VALUES($countryId)";

$Result1 = mysql_query($inserSQL ) or die(mysql_error());

edited Dec 8, 2011 at 18:43

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

answered Dec 8, 2011 at 18:30

emco

4,7493 gold badges21 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lance Cleveland Over a year ago

The real issue is not the quotes around the data but the fact that $_POST['country'] may come back blank or empty. MySQL will interpret '' as an empty STRING not an int whereas '0' it will recognize and auto-convert to an int. This code works because of the (int) typecast on $_POST['country'] which turns (int)'' into 0.

Tadiwanashe · Accepted Answer · 2018-11-20 12:20:28Z

0

I once experienced this problem and apparently i had a typo instead of putting a 0 i typed an O "Letter O" and that value was not expected in the database because the database field only accepted integers.

Make sure in your the value being passed from your code is integer type.

answered Nov 20, 2018 at 12:20

Tadiwanashe

1,31214 silver badges15 bronze badges

Collectives™ on Stack Overflow

Incorrect integer value: '' for column error

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related