Lines 39-45
sub search {
Link Here
|
39 |
borrowers.borrowernotes, borrowers.branchcode, borrowers.email, |
39 |
borrowers.borrowernotes, borrowers.branchcode, borrowers.email, |
40 |
borrowers.userid, borrowers.dateofbirth, borrowers.categorycode, |
40 |
borrowers.userid, borrowers.dateofbirth, borrowers.categorycode, |
41 |
categories.description AS category_description, categories.category_type, |
41 |
categories.description AS category_description, categories.category_type, |
42 |
branches.branchname"; |
42 |
branches.branchname, borrowers.phone"; |
43 |
my $from = "FROM borrowers |
43 |
my $from = "FROM borrowers |
44 |
LEFT JOIN branches ON borrowers.branchcode = branches.branchcode |
44 |
LEFT JOIN branches ON borrowers.branchcode = branches.branchcode |
45 |
LEFT JOIN categories ON borrowers.categorycode = categories.categorycode"; |
45 |
LEFT JOIN categories ON borrowers.categorycode = categories.categorycode"; |