Lines 64-70
sub search {
Link Here
|
64 |
borrowers.borrowernotes, borrowers.branchcode, borrowers.email, |
64 |
borrowers.borrowernotes, borrowers.branchcode, borrowers.email, |
65 |
borrowers.userid, borrowers.dateofbirth, borrowers.categorycode, |
65 |
borrowers.userid, borrowers.dateofbirth, borrowers.categorycode, |
66 |
categories.description AS category_description, categories.category_type, |
66 |
categories.description AS category_description, categories.category_type, |
67 |
branches.branchname"; |
67 |
branches.branchname, borrowers.phone"; |
68 |
my $from = "FROM borrowers |
68 |
my $from = "FROM borrowers |
69 |
LEFT JOIN branches ON borrowers.branchcode = branches.branchcode |
69 |
LEFT JOIN branches ON borrowers.branchcode = branches.branchcode |
70 |
LEFT JOIN categories ON borrowers.categorycode = categories.categorycode"; |
70 |
LEFT JOIN categories ON borrowers.categorycode = categories.categorycode"; |