summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorprashantsinalkar2017-05-11 10:35:16 +0530
committerprashantsinalkar2017-05-11 10:35:16 +0530
commitfdce8b8b09ae2b7deb798c2108c60e352ee81404 (patch)
treedec733a9c2cfe27d8fd8452da458179d597b8959
parent905dad1e6a77f456544d3575af43daab91ee2f2e (diff)
downloadtextbook_companion_fixer-fdce8b8b09ae2b7deb798c2108c60e352ee81404.tar.gz
textbook_companion_fixer-fdce8b8b09ae2b7deb798c2108c60e352ee81404.tar.bz2
textbook_companion_fixer-fdce8b8b09ae2b7deb798c2108c60e352ee81404.zip
data fetched in order
-rw-r--r--textbook_companion_fixer_edit_book_category.inc2
1 files changed, 1 insertions, 1 deletions
diff --git a/textbook_companion_fixer_edit_book_category.inc b/textbook_companion_fixer_edit_book_category.inc
index 531e07a..a4c421e 100644
--- a/textbook_companion_fixer_edit_book_category.inc
+++ b/textbook_companion_fixer_edit_book_category.inc
@@ -272,7 +272,7 @@ function _tbc_fixer_list_of_new_category($pref_id)
FROM list_of_category loc
LEFT JOIN textbook_companion_book_main_subcategories tcbms ON loc.category_id = tcbms.main_category
LEFT JOIN list_of_subcategory los ON los.subcategory_id = tcbms.sub_category
- WHERE tcbms.pref_id = :pref_id
+ WHERE tcbms.pref_id = :pref_id ORDER BY loc.category_id
";
$args = array(
':pref_id' => $pref_id