- Patch #166205 by hswong3i: improved database compatibility of db_result(). Makes it work with DB2, Oracle, etc.

1 files changed, 5 insertions, 5 deletions

diff --git a/includes/database.mysqli.inc b/includes/database.mysqli.inc
index 883bd72f6..38c3ce572 100644
--- a/includes/database.mysqli.inc
+++ b/includes/database.mysqli.inc
@@ -211,14 +211,14 @@ function db_num_rows($result) {
 *
 * @param $result
 *   A database query result resource, as returned from db_query().
-* @param $row
-*   The index of the row whose result is needed.
 * @return
 *   The resulting field or FALSE.
 */
-function db_result($result, $row = 0) {
-  if ($result && mysqli_num_rows($result) > $row) {
-    $array = mysqli_fetch_array($result, MYSQLI_NUM);
+function db_result($result) {
+  if ($result && mysqli_num_rows($result) > 0) {
+    // The mysqli_fetch_row function has an optional second parameter $row
+    // but that can't be used for compatibility with Oracle, DB2, etc.
+    $array = mysqli_fetch_row($result);
     return $array[0];
   }
   return FALSE;