$sql = "INSERT INTO blah (blah, blah...)"
. "VALUES ($an, $ct, ...)";

##</code><code>##

"VALUES ('$str1', '$str2', $num)"

##</code><code>##

$sth = $dbh->prepare($sql) or warn(...);
$sth->bind_columns(\($an, $ct, ...));