View source for Selecting data using JDatabase

==== loadResult() ==== <!--T:33-->
</translate>
<translate><!--T:34-->
Use '''loadResult()''' when you expect just a single value back from your database query.</translate>

{| class="wikitable" style="text-align:center"
|-
! <translate><!--T:35-->
id</translate> !! <translate><!--T:36-->
name</translate> !! <translate><!--T:37-->
email</translate> !! <translate><!--T:38-->
username</translate>
|-
| 1 || style="background:yellow" | John Smith || <translate><!--T:39-->
johnsmith@domain.example</translate> || johnsmith
|-
| 2 || Magda Hellman || <translate><!--T:40-->
magda_h@domain.example</translate> || magdah
|-
| 3 || Yvonne de Gaulle || <translate><!--T:41-->
ydg@domain.example</translate> || ydegaulle
|}

<translate><!--T:42-->
This is often the result of a 'count' query to get the number of records:</translate>

<syntaxhighlight lang="php">
use Joomla\CMS\Factory;
$db = Factory::getContainer()->get('DatabaseDriver');
$query = $db->getQuery(true);
$query->select('COUNT(*)');
$query->from($db->quoteName('#__my_table'));
$query->where($db->quoteName('name')." = :value");
$query->bind('value', $value)

// Reset the query using our newly populated query object.
$db->setQuery($query);
$count = $db->loadResult();
</syntaxhighlight>
<translate><!--T:134-->
or where you are just looking for a single field from a single row of the table (or possibly a single field from the first row returned).</translate>
<syntaxhighlight lang='php'>
use Joomla\CMS\Factory;
$db = Factory::getContainer()->get('DatabaseDriver');
$query = $db->getQuery(true);
$query->select('field_name');
$query->from($db->quoteName('#__my_table'));
$query->where($db->quoteName('some_name')." = :value");
$query->bind(':value', $some_value);

$db->setQuery($query);
$result = $db->loadResult();
</syntaxhighlight>

<translate>