Lines 28-36
sub search {
Link Here
|
28 |
|
28 |
|
29 |
my $dbh = C4::Context->dbh; |
29 |
my $dbh = C4::Context->dbh; |
30 |
my $select = "SELECT |
30 |
my $select = "SELECT |
31 |
borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address, |
31 |
borrowers.borrowernumber, borrowers.surname, borrowers.firstname, |
32 |
borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country, |
32 |
borrowers.streetnumber, borrowers.streettype, borrowers.address, |
33 |
cardnumber, borrowers.dateexpiry, |
33 |
borrowers.address2, borrowers.city, borrowers.state, borrowers.zipcode, |
|
|
34 |
borrowers.country, cardnumber, borrowers.dateexpiry, |
34 |
borrowers.borrowernotes, borrowers.branchcode, borrowers.email, |
35 |
borrowers.borrowernotes, borrowers.branchcode, borrowers.email, |
35 |
categories.description AS category_description, categories.category_type, |
36 |
categories.description AS category_description, categories.category_type, |
36 |
branches.branchname"; |
37 |
branches.branchname"; |