diff options
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( |