$dbc->do( "INSERT INTO color02 ( hexcode ) VALUES ( ? )", undef, $id ); #my $db_result = $dbc->prepare('SELECT hexcode FROM color02 ORDER BY id DESC LIMIT 1'); #$db_result->execute() or die $db_result->err_str; my ($dbc) = @_; my @row; my $sql = "SELECT hexcode, ts FROM color02 ORDER BY id DESC LIMIT 1"; my $sth = $dbc->prepare($sql);