RE: using data return from DBI SELECT statement

Tim McGeary wrote: > This is probably a very newbie-type of question, but I have this code > which a question noted by the ** below. > [snip] ># join patrons to respective disciple default lists ># bib_databases >my $sth2 = $dbh->prepare("SELECT bib_database_id FROM >

Re: using data return from DBI SELECT statement

> This is probably a very newbie-type of question, but I have this code > which a question noted by the ** below. > > my $sth = $dbh->prepare("SELECT * FROM patrons WHERE patron_id=$patron_id"); > $sth -> execute(); > > # check to see if record is in database > if (my $ref = $sth

RE: using data return from DBI SELECT statement

This is probably a very newbie-type of question, but I have this code which a question noted by the ** below. my $sth = $dbh->prepare("SELECT * FROM patrons WHERE patron_id=$patron_id"); $sth -> execute(); # check to see if record is in database if (my $ref = $sth->fetchrow_hashr

using data return from DBI SELECT statement

This is probably a very newbie-type of question, but I have this code which a question noted by the ** below. my $sth = $dbh->prepare("SELECT * FROM patrons WHERE patron_id=$patron_id"); $sth -> execute(); # check to see if record is in database if (my $ref = $sth->fetchrow_hashref()