Joomla! Documentation™

Description

Load a assoc list of database rows.

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

Syntax

loadAssocList($key=null, $column=null)

Parameter Name	Default Value	Description
$key	null	The field name of a primary key.
$column	null	An optional column name. Instead of the whole row, only this column value will be in the return array.

Returns

array If is empty as sequential list of returned records.

Defined in

libraries/joomla/database/database/mysql.php

Importing

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

Source Body

public function loadAssocList($key = null, $column = null)
{
        if (!($cur = $this->query())) {
                return null;
        }
        $array = array();
        while ($row = mysql_fetch_assoc($cur)) {
                $value = ($column) ? (isset($row[$column]) ? $row[$column] : $row) : $row;
                if ($key) {
                        $array[$row[$key]] = $value;
                } else {
                        $array[] = $value;
                }
        }
        mysql_free_result($cur);
        return $array;
}

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