From 7e4ef0eb0ad89acc3a7d117879936b21e8586547 Mon Sep 17 00:00:00 2001
From: Jayaram R Pai
Date: Wed, 16 Jul 2014 17:08:24 +0530
Subject: applied search.inc patch
---
search.inc | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/search.inc b/search.inc
index 5573d3a..e274949 100755
--- a/search.inc
+++ b/search.inc
@@ -161,11 +161,11 @@ function textbook_companion_browse_student()
return $return_html;
}
$book_rows = array();
- $query = "SELECT * FROM textbook_companion_proposal WHERE full_name like '".$query_character."%' ORDER BY full_name ASC";
+ $query = "SELECT *, pro.id AS proposal_id, pre.id AS preference_id FROM textbook_companion_proposal pro LEFT JOIN textbook_companion_preference pre ON pro.id = pre.proposal_id WHERE full_name
$student_q = db_query($query);
while ($student_data = db_fetch_object($student_q))
{
- $query = "SELECT * FROM textbook_companion_preference WHERE proposal_id = " . $student_data->id . " AND approval_status = 1";
+ $query = "SELECT * FROM textbook_companion_preference WHERE proposal_id = " . $student_data->proposal_id . " AND approval_status = 1";
$book_q = db_query($query);
while ($book_data = db_fetch_object($book_q))
{
--
cgit