$row       = array();

// gallery link info
$query = "SELECT title"
. "\n FROM #__rollerpics"
. "\n WHERE published = 1"
. "\n AND archived = 0"
. "\n ORDER BY ordering";

$database->setQuery( $query );
$result = $database->loadResult();
$row = $database->loadObjectList();

echo $database;
echo "<br />";
echo $row;
echo "<br />";
echo $result;

================
new results:

Object id #2
Array
2004 Club-Q Opening <--- the result i was looking for!!