Changeset 18573 for trunk/include/dblayer/functions_mysql.inc.php

Timestamp:

Oct 9, 2012, 6:58:57 AM (12 years ago)

Author:

rvelices

Message:

batch manager - remove unused code, less sql queries and avoid 4 calls to same display_select function

File:

• trunk/include/dblayer/functions_mysql.inc.php (modified) (1 diff)

trunk/include/dblayer/functions_mysql.inc.php

@@ -190 +190 @@
  *
  * @param string $query
- * @param string $fieldname
+ * @param string $fieldname optional
  * @return array
  */
-function array_from_query($query, $fieldname)
+function array_from_query($query, $fieldname=false)
 {
   $array = array();
 
   $result = pwg_query($query);
-  while ($row = mysql_fetch_assoc($result))
-  {
-    $array[] = $row[$fieldname];
-  }
-
+  if (false === $fieldname)
+  {
+    while ($row = mysql_fetch_assoc($result))
+    {
+      $array[] = $row;      
+    }
+  }
+  else
+  {
+    while ($row = mysql_fetch_assoc($result))
+    {
+      $array[] = $row[$fieldname];
+    }
+  }
   return $array;
 }