Support Joomla!

references:joomla.framework:database:jdatabase-loadassoc

Trace: » jdatabase-loadassoc
 
Table of Contents

loadAssoc

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

Executes the current query and returns the first result row in an associative array.

Syntax

void loadAssoc ()

Examples

Example

$dbo =& JFactory::getDBO();

$query = "SELECT name, clickurl FROM #__banner";
$dbo->setQuery( $query );
$row = $dbo->loadAssoc();
print_r( $row );
echo "<br />";
$row = $dbo->loadAssoc();
print_r( $row );

might produce:

Result

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

Note that this method can only be used to obtain the first result (as illustrated above).

Discussion

Full name:
E-Mail:
 
references/joomla.framework/database/jdatabase-loadassoc.txt (845 views) · Last modified: 2007/08/15 14:52
 
Recent changes RSS feed Driven by DokuWiki