Select Code to Download

my $query = $dbh->prepare
    ( "select id, name from user where name = ?" );
$query->execute( $name_from_params );

my $query = $dbh->prepare
    ( "select id, name from user " .
      "where name = '$name_from_params'" );
$query->execute();