Get record of first (and only) row?

NoNoNo

How to get the record of the first (and only) row?

// in BasePresenter:
$this->template->users = $this->DB->table('users'); // $this->DB is Nette\Database\Context

// in template:
{if count($users) == 1}
  {$users->current()->name} // Does not work
{/if}

Thanks & greetings!

Pavel Kravčík

$this->DB->table('users')->fetch()

GEpic

Are you sure you want to get “first” record without any ORDER?

Pavel Kravčík

@GEpic: I guess he starts playing with sandbox. So he has only one user for this purpose.

NoNoNo

My aim is to have two different outputs in one template:

In the second case (single user), this works (but is ugly) to print name of first and only user:

{foreach $users as $user}{/foreach}{$user->name}

This does not work:

{$this->DB->table('users')->fetch()->name}

Or is this approach generally wrong?

Ondřej Kubíček

you have to specify which user you want
you probaly want user with id 123

$this->DB->table('users')->where('id', $id)->fetch()->name

or better way

$this->DB->table('users')->get($id)->name