Can someone explain why passing the parameter behave like it did or atleast explain the best way to pass parameters here?
$dbh = DBI->connect('dbi:mysql:userdb','user', 'pw');
$sth=$dbh->prepare("SELECT * FROM myusers where username = ?");
#this works
$sth->execute(bob) || die "SQL error: $!\n";
#this did NOT work with double quotes why?
$sth->execute("bob") || die "SQL error: $!\n";
thanks,
-rkl
