Differences

This shows you the differences between two versions of the page.

--- reference:concat [2015/07/20 14:08] – created mnewnham
+++ v5:reference:connection:concat [2016/01/18 02:12] – mnewnham
@@ Line 1: / Line 1: @@
-====== Concat ======
+====== concat ======
 ~~NOTOC~~
 <WRAP right box>
@@ Line 7: / Line 7: @@
 </WRAP>
 ===== Description =====
-The function ''concat()'' takes an input CSV list strings, and returns a database-specific string of concatenated values
+The function ''concat()'' takes an variable list of strings, and returns a database-specific string of concatenated values. It is important to recognize the difference between concatenating a database field or a string whn using the method in an SQL statement
+-------------------------------
 ===== Usage =====
 <code php>
@@ Line 13: / Line 14: @@
  * Assume MySQL database
  */
-$list = 'VOGON,POETRY,READING';
+$list = 'VOGON','POETRY','READING';
 $string = $db->concat($list);
@@ Line 21: / Line 22: @@
 */
 </code>
+===== Concatenating Strings And Database Fields =====
+In order to concatenate database fields and strings together it is necessary to quote the strings
+<code php>
+/*
+* Best methodology
+*/
+$s = $db->quote(', Arthur Dent');
+$SQL = "UPDATE hitchhikers
+           SET last_name = {$db->concat(last_name,$s)}
+         WHERE first_name='Arthur'
+           AND last_name='Dent'";
+$db->execute($SQL);
+$SQL = "SELECT last_name FROM hitchhikers
+         WHERE first_name='Arthur'";
+print $db->getOne($SQL);
+/*
+* Prints "Dent, Arthur Dent"
+*/
+</code>