A very easy mysql problem

I want to compare the password, which the user typed in (in a textfield) =
with a password, which is in a MySQL-db.

I tried the following:


=09my $dbh =3D db_open("mypoll300903", "testuser", "authmysql");
=09my $sth =3D $dbh->prepare("select password from table1 where prename =3D=
=20\"testprename\" and name =3D \"testname\";")
=09 or die ($dbh->errstr);
=09$sth->execute or die $sth->errstr;
=09print "$sth";=09
=09$dbh->disconnect();=20

$sth is not yet what I want. It is something like the structure of what I=
=20need.

=09I'd like to do the following:

=09if ($passdb es $passusr) { ## $passdb =3D the transformed $sth=20
=09 $OK =3D 1;
=09}



Any help will be greatly appreciated,

Thomas



Content Security by MailMarshal

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org