Put dot between two variables in a string

Question

how can I put a dot between two variables in mysql? Something like this, but it doesn't work:

$query_filename->execute(array(".$value.".".$ext.", $key));

So the table would read (for example): file.txt

Thank you!

`".$value."` will add 2 literal `.` characters to your string. — gen_Eric, Apr 04 '13 at 20:37
You could always concatenate the string in a command before... — Lix, Apr 04 '13 at 20:37
possible duplicate of [What is the best way to add two strings together?](http://stackoverflow.com/questions/695124/what-is-the-best-way-to-add-two-strings-together) — mario, Apr 04 '13 at 20:38

score 1 · Accepted Answer · answered Apr 04 '13 at 20:40

1

"file.txt" (or any variation) isn't even remotely valid SQL. It isn't a query, just a filename.

In PHP, then to achieve what you want, try:

array($value . '.' . $ext,$key);

In MySQL, your query should include

CONCAT(value,".",ext)

answered Apr 04 '13 at 20:40

thelr

1 Answers1