|
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"; |