$dbh->getOne($query, $params = array())

[beingchinmay]

The getOne() method returns the first column from the first row of data. Use the $params parameter if $query contains placeholders (this applies to the rest of the convenience functions, too). Here's an exampl

$name = $dbh->getOne('SELECT name FROM users WHERE id = ?',
array($_GET['userid']));