|
Lines 30-36
sub search {
Link Here
|
| 30 |
my $select = "SELECT |
30 |
my $select = "SELECT |
| 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 |
cardnumber, borrowers.dateexpiry, |
| 34 |
borrowers.borrowernotes, borrowers.branchcode, borrowers.email, |
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 |
- |
|
|