$get = $dbh->prepare("SELECT * FROM clients ORDER BY lastname");
$get->execute;

##</code><code>##

$clients = $get->fetchall_hashref('id');

##</code><code>##

@list = keys(%{$clients});