PHP insert statement containing numbers is wrong

Question

I have got this statement:

   $query="INSERT INTO error_report(task_id,url_is_route, forbidden_word, google_host_fail, google_cache_fail, google_title_fail, google_element_fail, robots_noindex_nofollow, xrobots_noindex_nofollow, title_fetch_warn, h1_fail,h2_fail,h3_fail ,h1_warn ,h2_warn, h3_warn)
         VALUES (".$this->task_id.",0,0,0,0,0,0,0,0,0,0,0,0,0,0)";   


mysql_query($query) or die(mysql_error());

I get this:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,0,0,0,0,0,0,0,0,0,0,0,0,0)' at line 2

Where does the problem lie?

UPDATE

$query="INSERT INTO error_report(task_id,url_is_route, forbidden_word, google_host_fail, google_cache_fail, google_title_fail, robots_noindex_nofollow, xrobots_noindex_nofollow, title_fetch_warn, h1_fail,h2_fail,h3_fail ,h1_warn ,h2_warn, h3_warn)
             VALUES ('".$this->task_id."','0','0','0','0','0','0','0','0','0','0','0','0','0','0')";

Now I get:

Incorrect integer value: '' for column 'task_id' at row 1

I think you need to quote each entry. Like '".$this->task_id."', '0' — user1231969
– user1231969, Commented Apr 30, 2012 at 6:14
@DmitryMakovetskiyd: Can you output the value of $query prior to its execution and show us? — eggyal
– eggyal, Commented Apr 30, 2012 at 6:16
I think you've forgotten one zero for the values (if i've counted correctly, you have 16 fields and 15 values)... Oh, and what's the value of $this->task_id? — Yaniro
– Yaniro, Commented Apr 30, 2012 at 6:16
@Dmitry Have you actually tried with quotes? If not please first try it. This a very common problem. — user1231969
– user1231969, Commented Apr 30, 2012 at 6:19

skos · Accepted Answer · 2012-04-30 06:20:47Z

2

Use quotes
You are trying to update 16 columns but entering only 15 values. Correct that.

answered Apr 30, 2012 at 6:20

skos

4,2628 gold badges39 silver badges59 bronze badges

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

2 Comments

skos Over a year ago

Could you please tell me of what 'type' is the column task_id in database and what actually is the value of $this->task_id ?

skos Over a year ago

try to put a hardcoded value instead of $this->task_id in the query. If it works then may be $this->task_id is empty

eggyal · Accepted Answer · 2012-04-30 06:29:54Z

2

Incorrect integer value: '' for column 'task_id' at row 1

$this->task_id is empty and does not contain 116 as you suspect.

answered Apr 30, 2012 at 6:29

eggyal

127k18 gold badges220 silver badges244 bronze badges

Comments

Sudhir Bastakoti · Accepted Answer · 2012-04-30 06:16:23Z

1

How about just setting Default Value of fields to 0 and doing:


$query="INSERT INTO error_report(task_id) VALUES (".$this->task_id.")";

answered Apr 30, 2012 at 6:16

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

3 Comments

Dmitry Makovetskiyd Over a year ago

Column count doesn't match value count at row 1

Sudhir Bastakoti Over a year ago

use exactly one field name with one value for the field in your insert statement like i mentioned in answer above... and that should solve the error

Dmitry Makovetskiyd Over a year ago

I have one field that is autoincremented

nithi · Accepted Answer · 2012-04-30 06:29:47Z

1

Check these

$this->task_id contains the value and not it is empty
$this->task_id has an integer value in it or any characters. I think the column is int, so if it contains non integer values it throws an error

answered Apr 30, 2012 at 6:29

nithi

3,9072 gold badges22 silver badges18 bronze badges

Collectives™ on Stack Overflow

PHP insert statement containing numbers is wrong

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related