Table of Contents

loadAssocList

API Package Subpackage Class Method Reference Last reviewed Doc status
API Home Package Joomla.Framework Subpackage Database Class JDatabase Method loadAssocList Reference loadAssocList() Never Work in Progress

Loads an associative list of database rows. If the $key parameter is set, the specified field will be used as the index for the array. Otherwise, sequential numbering will be used for the array.

Syntax

array loadAssocList ( $key )

$key string is a string containing the name of a field in the query to be used as the array index (key). This paramter is optional and if omitted the entries will be numbered sequentially.

Examples

Example

$dbo =& JFactory::getDBO();

$query = "SELECT bid, name, clickurl FROM #__banner";
$dbo->setQuery( $query );
$row =& $dbo->loadAssocList( 'bid' );
print_r( $row );

might produce:

Result

Array
(
    [1] => Array
        (
            [bid] => 1
            [name] => OSM 1
            [clickurl] => http://www.opensourcematters.org
        )

    [2] => Array
        (
            [bid] => 2
            [name] => OSM 2
            [clickurl] => http://www.opensourcematters.org
        )

    [3] => Array
        (
            [bid] => 3
            [name] => Joomla!
            [clickurl] => http://www.joomla.org
        )

    [4] => Array
        (
            [bid] => 4
            [name] => Joomla! Forge
            [clickurl] => http://forge.joomla.org
        )

    [5] => Array
        (
            [bid] => 5
            [name] => Joomla! Extensions
            [clickurl] => http://extensions.joomla.org
        )

)