diff options
| author | prashantsinalkar | 2016-04-13 15:06:28 +0530 |
|---|---|---|
| committer | prashantsinalkar | 2016-04-13 15:06:28 +0530 |
| commit | 3f72ea7c0b573eb58dec1b28e45f5cdb1770bb2f (patch) | |
| tree | f5e3a19c346044127b4f1c01200dc96712c1c112 /search.inc | |
| parent | 6a228171041526a1b4df158850793d0519364dc4 (diff) | |
| download | scilab_textbook_companion-3f72ea7c0b573eb58dec1b28e45f5cdb1770bb2f.tar.gz scilab_textbook_companion-3f72ea7c0b573eb58dec1b28e45f5cdb1770bb2f.tar.bz2 scilab_textbook_companion-3f72ea7c0b573eb58dec1b28e45f5cdb1770bb2f.zip | |
modified filter query for search
Diffstat (limited to 'search.inc')
| -rwxr-xr-x | search.inc | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -77,7 +77,7 @@ while ($search_data = $search_q->fetchObject()) pe.publisher as publisher, pe.year as year, pe.id as pe_id, po.approval_date as approval_date FROM textbook_companion_preference pe LEFT JOIN textbook_companion_proposal po ON pe.proposal_id = po.id WHERE po.proposal_status = 3 AND pe.approval_status = 1 AND - (book LIKE :book OR author LIKE :author OR po.full_name LIKE :contributor) ORDER BY pe.author ASC + (book LIKE :book OR author LIKE :author OR po.full_name LIKE :contributor) ORDER BY author ASC ", array(":book" => '%%'.trim($form_state['values']['search']).'%%', ":author" => '%%'.trim($form_state['values']['search']).'%%', |