Differences

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

--- v5:reference:connection:concat [2016/01/18 02:09] – [Usage] mnewnham
+++ v5:reference:connection:concat [2016/01/29 21:34] (current) – mnewnham
@@ Line 7: / Line 7: @@
 </WRAP>
 ===== Description =====
-The function ''concat()'' takes an input CSV 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
+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 when using the method in an SQL statement
 -------------------------------
 ===== Usage =====
@@ Line 14: / Line 14: @@
  * Assume MySQL database
  */
-$list = 'VOGON','POETRY','READING';
+$string = $db->concat('VOGON','POETRY','READING');
-$string = $db->concat($list);
 /*
- * Returns: CONCAT(VOGON,POETRY,READING);
+ * Returns: CONCAT(VOGON,POETRY,READING)
+ * assuming that they are database columns
 */
 </code>