PHP / MySql - Concatenation in query

Question

I am having problems concatenating a variable to a number (with the variable first, because $info1002 is not a known variable), I appreciate my problem here must be my single double quotations and I've tried a lot of combinations and my googling hasn't helped.

mysql_query("INSERT INTO users (ID, info1) VALUES ('','.$info.''002')")or die(mysql_error());

cassi.lup · Accepted Answer · 2012-09-04 12:02:42Z

4

you need to format it like this:

mysql_query("INSERT INTO users (ID, info1) VALUES ('','".$info."002')") or die(mysql_error());

Also, if you have the ID field set to AutoIncrement, you can ommit it like this:

mysql_query("INSERT INTO users (info1) VALUES ('".$info."002')") or die(mysql_error());

This will insert value of $info followed by 002 into the database.

edited Sep 4, 2012 at 12:02

answered Sep 4, 2012 at 11:41

cassi.lup

1,2617 silver badges24 bronze badges

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

1 Comment

EnglishAdam Over a year ago

works +1, personally i like to keep my AI's visible so i remember what the H i'm trying to do! Thanks

Rab Khan · Accepted Answer · 2012-09-04 11:41:30Z

2

mysql_query("INSERT INTO users (ID, info1) VALUES ('','".$info."002"')")or die(mysql_error());

answered Sep 4, 2012 at 11:41

Rab Khan

35.7k4 gold badges52 silver badges66 bronze badges

Comments

user745235 · Accepted Answer · 2012-09-04 11:43:37Z

1

why don't you concatenate if before adding it to the query? I think it is much easier so you don't have that mass with quotation.

$var = $info.'002';
mysql_query("INSERT INTO users (ID, info1) VALUES (null ,'".$var."') or die(mysql_error());

answered Sep 4, 2012 at 11:43

user745235

Comments

Svetoslav · Accepted Answer · 2012-09-04 13:11:33Z

0

mysql_query("INSERT INTO users (info1) VALUES ('{$info}002')")or die(mysql_error());

It may not work only if your ID is set NOT NULL and it not set as autoincrement!

edited Sep 4, 2012 at 13:11

answered Sep 4, 2012 at 11:41

Svetoslav

4,6862 gold badges30 silver badges43 bronze badges

1 Comment

EnglishAdam Over a year ago

The page threw a syntax error... you have an ' too many maybe?

Collectives™ on Stack Overflow

PHP / MySql - Concatenation in query

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related