The list of previous borrowers on moredetail.pl shows the three oldest
rather than the three most recent as I expected. This changes the sql
to order descending so we get the three most recent.
---
C4/Items.pm | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diff --git a/C4/Items.pm b/C4/Items.pm
index dd78f98..d222af1 100644
--- a/C4/Items.pm
+++ b/C4/Items.pm
@@ -1295,6 +1295,7 @@ sub GetItemsInfo {
my $sth2 = $dbh->prepare("SELECT * FROM old_issues,borrowers
WHERE itemnumber = ?
AND old_issues.borrowernumber =
borrowers.borrowernumber
+ ORDER BY returndate DESC
LIMIT 3");
$sth2->execute($data->{'itemnumber'});
my $ii = 0;
--
1.5.4.3
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
