Codeigniter 2.1 - MySQL CONCAT (append string)

Question

I have PHP code like this:

$query = 'UPDATE  `user_vote` SET `container` = CONCAT(`container`, ' ;
$query .=  ",$glas";
$query .= ') WHERE `user_id` = ' . $id_u;
$this->db->query($query);

When I run this code, I got following error:

Error Number: 1054

Unknown column ',iljadu' in 'field list'

UPDATE user_vote SET container = CONCAT(container, ,iljadu) WHERE user_id = 4

What is wrong with the query?

Fluffeh · Accepted Answer · 2012-08-10 13:12:29Z

4

You are missing quotes around your variable for the concat()

$query = 'UPDATE  `user_vote` SET `container` = CONCAT(`container`, ' ;
$query .=  ",'$glas'";
$query .= ') WHERE `user_id` = ' . $id_u;
$this->db->query($query);

answered Aug 10, 2012 at 13:12

Fluffeh

33.6k16 gold badges69 silver badges80 bronze badges

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

4 Comments

DaveRandom Over a year ago

$glas could contain a column identifier, but I suspect you are correct. Still too many commas though... ;-)

Fluffeh Over a year ago

@DaveRandom Concat() can contain a column name or a string. In this case my big nose is telling me that it is a string that is being appended with a column - in which case there are quotes missing around it. I got a good feeling about this one :)

Sasha Over a year ago

This is working, thank you :). @DaveRandom I need coma, but I put it at wrong place. ",'$glas'"; should be "',$glas'"; and everything works fine.

Fluffeh Over a year ago

@Sasha Super, feel free to Accept the answer and we can all call it a night :)

Laurence · Accepted Answer · 2012-08-10 13:11:57Z

1

$query .=  ",$glas";

should be

$query .=  "$glas";

answered Aug 10, 2012 at 13:11

Laurence

60.2k22 gold badges178 silver badges215 bronze badges

1 Comment

Fluffeh Over a year ago

Concat() has parameters that are separated by commas?

Collectives™ on Stack Overflow

Codeigniter 2.1 - MySQL CONCAT (append string)

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related