From 2892f6e69b063d5a9b4b83c098a5e057a5b25873 Mon Sep 17 00:00:00 2001 From: Michael Hafen Date: Wed, 1 Oct 2008 14:14:56 -0600 Subject: [PATCH] bugfix: Sort previous borrowers descending in Items.pm for moredetail.pl 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. Signed-off-by: Galen Charlton --- C4/Items.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/C4/Items.pm b/C4/Items.pm index 1f92491a93..3aef697c5b 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; -- 2.39.5