Lines 31-37
sub search {
Link Here
|
31 |
borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address, |
31 |
borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address, |
32 |
borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country, |
32 |
borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country, |
33 |
CAST(borrowers.cardnumber AS UNSIGNED) AS cardnumber, borrowers.dateexpiry, |
33 |
CAST(borrowers.cardnumber AS UNSIGNED) AS cardnumber, borrowers.dateexpiry, |
34 |
borrowers.borrowernotes, borrowers.branchcode, |
34 |
borrowers.borrowernotes, borrowers.branchcode, borrowers.email, |
35 |
categories.description AS category_description, categories.category_type, |
35 |
categories.description AS category_description, categories.category_type, |
36 |
branches.branchname"; |
36 |
branches.branchname"; |
37 |
my $from = "FROM borrowers |
37 |
my $from = "FROM borrowers |