public static function selectMultiple(
        $fieldNames,
        $tableNames,
        $whereClause = '',
        $groupBy = '',
        $orderBy = '',
        $limit = ''
    ) {
        $result = [];
        $dbResult = self::select(
            $fieldNames,
            $tableNames,
            $whereClause,
            $groupBy,
            $orderBy,
            $limit
        );

        $databaseConnection = self::getDatabaseConnection();
        while ($recordData = $databaseConnection->sql_fetch_assoc($dbResult)) {
            $result[] = $recordData;
        }
        $databaseConnection->sql_free_result($dbResult);

        return $result;
    }
public static function selectMultiple(
        $fieldNames,
        $tableNames,
        $whereClause = '',
        $groupBy = '',
        $orderBy = '',
        $limit = ''
    ) {
        $result = [];
        $dbResult = self::select(
            $fieldNames,
            $tableNames,
            $whereClause,
            $groupBy,
            $orderBy,
            $limit
        );

        $databaseConnection = self::getDatabaseConnection();
        while ($recordData = $databaseConnection->sql_fetch_assoc($dbResult)) {
            $result[] = $recordData;
        }
        $databaseConnection->sql_free_result($dbResult);

        return $result;
    }
public static function selectMultiple ( $ fieldNames , $ tableNames , $ whereClause = '' , $ groupBy = '' , $ orderBy = '' , $ limit = '' ) { $ result = [ ] ; $ dbResult = self :: select ( $ fieldNames , $ tableNames , $ whereClause , $ groupBy , $ orderBy , $ limit ) ; $ databaseConnection = self :: getDatabaseConnection ( ) ; while ( $ recordData = $ databaseConnection -> sql_fetch_assoc ( $ dbResult ) ) { $ result [ ] = $ recordData ; } $ databaseConnection -> sql_free_result ( $ dbResult ) ; return $ result ; }
Executes a SELECT query and returns the result rows as a two-dimensional
associative array.

@param string $fieldNames list of fields to select, may be "*", must not be empty
@param string $tableNames comma-separated list of tables from which to select, must not be empty
@param string $whereClause WHERE clause, may be empty
@param string $groupBy GROUP BY field(s), may be empty
@param string $orderBy ORDER BY field(s), may be empty
@param string $limit LIMIT value ([begin,]max), may be empty

@return array[] the query result rows, will be empty if there are no matching records
Executes a SELECT query and returns the result rows as a two - dimensional associative array .