Actions

API15

JDatabaseMySQL/loadRowList

From Joomla! Documentation

< API15:JDatabaseMySQL
Revision as of 08:59, 12 May 2013 by JoomlaWikiBot (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Replacement filing cabinet.png
This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.

Contents

Description

Load a list of database rows (numeric column indexing)

[<! removed edit link to red link >]

<! removed transcluded page call, red link never existed >

Syntax

loadRowList($key=null)
Parameter Name Default Value Description
$key null The field name of a primary key

Returns

array If is empty as sequential list of returned records. If is not empty then the returned array is indexed by the value the database key. Returns if the query fails.

Defined in

libraries/joomla/database/database/mysql.php

Importing

jimport( 'joomla.database.database.mysql' );

Source Body

function loadRowList( $key=null )
{
        if (!($cur = $this->query())) {
                return null;
        }
        $array = array();
        while ($row = mysql_fetch_row( $cur )) {
                if ($key !== null) {
                        $array[$row[$key]] = $row;
                } else {
                        $array[] = $row;
                }
        }
        mysql_free_result( $cur );
        return $array;
}

[<! removed edit link to red link >] <! removed transcluded page call, red link never existed >

Examples

<CodeExamplesForm />