diff options
| author | Dries Buytaert <dries@buytaert.net> | 2000-07-12 07:15:09 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2000-07-12 07:15:09 +0000 |
| commit | 75129c1fdda7585d16fe27e35bac8018bd8cfbee (patch) | |
| tree | 0f4515fc57efbc73fc726857b2972747017d17af /search.php | |
| parent | babf1a7de6f8e2d782ba605347cfd37d1b70e3a6 (diff) | |
| download | brdo-75129c1fdda7585d16fe27e35bac8018bd8cfbee.tar.gz brdo-75129c1fdda7585d16fe27e35bac8018bd8cfbee.tar.bz2 | |
Bugfixes:
(1) fixed SQL bug in search.php.
(2) fixed SQL bug in discussion.php.
(3) fixed theme-bug in submit.php.
(4) fixed theme-bug in discussion.php.
(5) fixed Dries2-theme: it more or less works now though
I still have to change the look/layout.
Important:
(3) and (4) did fix the i-suddenly-seem-to-log-out behavior.
Diffstat (limited to 'search.php')
| -rw-r--r-- | search.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/search.php b/search.php index c9568165b..cbb0b1dd6 100644 --- a/search.php +++ b/search.php @@ -42,7 +42,7 @@ ### Compose query: $query = "SELECT DISTINCT s.id, s.subject, u.userid, s.timestamp FROM stories s LEFT JOIN users u ON s.author = u.id WHERE s.status = 2 "; - if ($terms != "") $query .= "AND (s.subject LIKE '%$terms%' OR s.abstract LIKE '%$terms%' OR s.comments LIKE '%$terms%') "; + if ($terms != "") $query .= "AND (s.subject LIKE '%$terms%' OR s.abstract LIKE '%$terms%' OR s.updates LIKE '%$terms%') "; if ($category != "") $query .= "AND s.category = '$category' "; if ($author != "") $query .= "AND u.userid = '$author' "; if ($order == "Oldest first") $query .= " ORDER BY s.timestamp ASC"; |