[phpBT-dev] CVS: phpbt/inc functions.php,1.6,1.7

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/inc
In directory usw-pr-cvs1:/tmp/cvs-serv3329

Modified Files:
	functions.php 
Log Message:
Added concat function for using PEAR::DB

Index: functions.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/functions.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- functions.php	5 Mar 2002 23:55:28 -0000	1.6
+++ functions.php	17 Mar 2002 01:36:43 -0000	1.7
@@ -356,3 +356,22 @@
 	}
 	return $js;
 }
+
+///
+/// Database concat
+function db_concat() {
+	$pieces = func_get_args();
+	
+	switch(DB_TYPE) {
+		case 'mysql' : $retstr = 'concat('. delimit_list(', ', $pieces).')'; break;
+		case 'pgsql' :
+		case 'oci8' :
+		case 'sybase' :
+		case 'ibase' : $retstr = delimit_list(' || ', $pieces); break;
+		case 'fbsql' : $retstr = 'CONCAT('. delimit_list(', ', $pieces).')'; break;
+		default : $retstr = delimit_list(' + ', $pieces); break;
+  }
+  return $retstr
+}
+
+?>