diff options
| author | Jayaram Pai | 2014-02-24 17:36:13 +0530 |
|---|---|---|
| committer | Jayaram Pai | 2014-02-24 17:36:13 +0530 |
| commit | 9e25a2e31cc22ac02035d44081400f54d0cf964b (patch) | |
| tree | 3d4bc15c085bbd8dc4e7e29c7d3cb592d014d64a /tbc_external_review.module | |
| parent | 42a82cdd20fb394b95f3cd6b12d6ceee294af3b9 (diff) | |
| download | tbc-external-review-9e25a2e31cc22ac02035d44081400f54d0cf964b.tar.gz tbc-external-review-9e25a2e31cc22ac02035d44081400f54d0cf964b.tar.bz2 tbc-external-review-9e25a2e31cc22ac02035d44081400f54d0cf964b.zip | |
/status selected_books ordered by users.name
Diffstat (limited to 'tbc_external_review.module')
| -rw-r--r-- | tbc_external_review.module | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/tbc_external_review.module b/tbc_external_review.module index 09b868d..1d8745a 100644 --- a/tbc_external_review.module +++ b/tbc_external_review.module @@ -552,7 +552,8 @@ $page_content = ""; $query = " SELECT * from textbook_companion_preference tcp INNER JOIN external_review_details erd - ON (tcp.id = erd.preference_id AND erd.status=1) INNER JOIN users ON erd.uid = users.uid + ON (tcp.id = erd.preference_id AND erd.status=1) INNER JOIN users ON (erd.uid = users.uid) + ORDER BY users.name "; $result = db_query($query); $headers = array( @@ -574,7 +575,7 @@ $query = " SELECT * from textbook_companion_preference tcp INNER JOIN external_review_details erd - ON (tcp.id = erd.preference_id AND erd.status=0) INNER JOIN users ON erd.uid = users.uid + ON (tcp.id = erd.preference_id AND erd.status=0) INNER JOIN users ON (erd.uid = users.uid) "; $result = db_query($query); $headers = array( |