Re: Single value

[Simon Oliver]

"In a scalar context, fetchrow_array returns the value of the first field."

$val = $sth->fetchrow_array;

Alternatively, you could use a bind_col thus:

my $val;
$sth->bind_col(1, $val);
while ($sth->fetch) {
   print "$val\n";
}

-- 
   Simon Oliver