[lilly07]

Expand|Select|Wrap|Line Numbers

1. $sth = $dbh->prepare("select count(*) from test where status = 1 and name= '$name");
2.     $sth->execute();

How do I change the above statement so that the variable $name can be avoided inside a prepare statement as it is a vraible.

Thanks.

[eWish]

What do you mean by "avoided"?

--Kevin

[lilly07]

How to pass variables in sql prepared statement? Is there any other means of doing it?

[lilly07]

Yes Thx. I could do it as below:

Expand|Select|Wrap|Line Numbers

1. $sth = $dbh->prepare("select count(*) from test where status = 1 and name=?");
2. $sth->execute($name);

[eWish]

Placeholders and Bind Values

Expand|Select|Wrap|Line Numbers

1. my $sql = $dbh->prepare(q{SELECT name FROM test  WHERE user_id = (?)});
2.    $sql->execute($user_id);

--Kevin