help me for writing query in perl

[vapanchamukhi]

hi....

i want to write the query
select * from user where name = "richard"; in perl

the string richard i have taken that in the variable $name.

i have written the query as below

$sth = $dbh -> prepare('select * from user where name = "$name"');

is this correct way of writing in perl?

[Stwange]

hi....
$sth = $dbh -> prepare('select * from user where name = "$name"');

In Perl, " " interpolates variables, ' ' doesn't, so putting a " " inside a ' ' won't cause the variables to be read. Try this instead:

$sth = $dbh->prepare("SELECT * FROM user WHERE name ='$name' ");
#or, if you need double quotes in the query:
$sth = $dbh->prepare("SELECT * FROM user WHERE name = \"$name\"");
#or
$sth = $dbh->prepare('SELECT * FROM user WHERE name = "' . $name . '"');

Hope this helps.