# flakey
my $sth = $dbh->prepare_cached(<<SQL);
	SELECT *
	FROM foo
	WHERE id = ?
SQL
$sth->bind_param(1, $q->param('id'), SQL_INTEGER);
$sth->execute;

##</code><code>##

# functional
my $sth = $dbh->prepare_cached(<<SQL);
	SELECT *
	FROM foo
	WHERE id = ?
SQL
$sth->execute( $q->param('id') );