$dbh->connect(...);

$sth->prepare("SELECT COUNT(*) FROM table WHERE col=?");
$sth->execute($var);
($count)=$sth->fetchrow_array;

$dbh->disconnect;