1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
<?
# IRM - The Information Resource Manager
# Copyright (C) 1999 Yann Ramin
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License (in file COPYING) for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
#
# $Id: tracking-search.php3,v 1.2 2000/03/17 05:48:35 atrus Exp $
#
################################################################################
# CHANGELOG #
################################################################################
# 11/06/99 - Yann Ramin: Added file for searching #
################################################################################
include("../irm.inc");
AuthCheck("normal");
$db = new DB;
commonHeader("IRM Tracking - Search");
?>
<h3>Search Results</h3>
These are your search results for the query: description contains <? echo $contains; ?>.
<hr noshade>
<?
$query = "SELECT ID FROM tracking WHERE (contents LIKE \"%$contains%\") ORDER BY
date DESC";
$result = $db->query($query);
$i = 0;
$number = $db->numrows($result);
PRINT "<center><table border=1 width=\"100%\">";
PRINT "<tr bgcolor=#DDDDDD><td>Status</td><td>Date</td><td width=5>Pri</td>
<td>Author</td><td>Assigned</td><td>Computer</td><td colspan=2 width=70%>
Description</td></tr>";
while ($i < $number)
{
$ID = $db->result($result, $i, "ID");
Show_tracking($ID, 0);
$i++;
}
PRINT "</table></center>";
commonFooter();
?>
|
