-
Notifications
You must be signed in to change notification settings - Fork 0
/
1126.html
98 lines (88 loc) · 4.04 KB
/
1126.html
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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
<?php
elseif ($keyword!=NULL && $state_select!=NULL && $category_select==NULL) {
$query = "SELECT job.jid as id, types.t_name as name,types.color as color, job.title as title, job.company_name as company,
job.description as description, job.city as city,
job.state as state, job.post_date as created FROM job,types, categories where job.type_id = types.tid
and state = '$state_select' and (title LIKE '%$keyword%' or description LIKE '%$keyword%') GROUP BY id ORDER BY created desc";
$result = mysql_query($query);
if ($result!=""){
while ($jobs = mysql_fetch_assoc($result)) {?>
<li>
<div class="type">
<span style="background:<?php echo $jobs['color']; ?>"><?php echo $jobs['name']; ?></span>
</div>
<div class="description">
<a href="details.php"><h5 id="<?php echo $jobs['id']; ?>"><?php echo $jobs['title']; ?></a>
(<?php echo $jobs['city']; ?>, <?php echo $jobs['state']; ?>)</h5>
<span id="list_date">
<?php echo date($jobs['created']); ?>
</span>
<?php echo myTruncate($jobs['description'], 200, " "); ?>
</div>
</li>
<?php
} // end while
} // end if
else {?>
<li><img src="images/noresults.jpg"></li>
<?php }
mysql_free_result($result); }?> <?php
elseif ($keyword!=NULL && $state_select==NULL && $category_select!=NULL) {
$query = "SELECT job.jid as id, types.t_name as name,types.color as color, job.title as title, job.company_name as company,
job.description as description, job.city as city,
job.state as state, job.post_date as created FROM job,types, categories where job.type_id = types.tid
and job.cid = '$category_select' and (title LIKE '%$keyword%' or description LIKE '%$keyword%') GROUP BY id ORDER BY created desc";
$result = mysql_query($query);
if ($result!=""){
while ($jobs = mysql_fetch_assoc($result)) {?>
<li>
<div class="type">
<span style="background:<?php echo $jobs['color']; ?>"><?php echo $jobs['name']; ?></span>
</div>
<div class="description">
<a href="details.php"><h5 id="<?php echo $jobs['id']; ?>"><?php echo $jobs['title']; ?></a>
(<?php echo $jobs['city']; ?>, <?php echo $jobs['state']; ?>)</h5>
<span id="list_date">
<?php echo date($jobs['created']); ?>
</span>
<?php echo myTruncate($jobs['description'], 200, " "); ?>
</div>
</li>
<?php
} // end while
} // end if
else {?>
<li><img src="images/noresults.jpg"></li>
<?php }
mysql_free_result($result); }?>
<?php
// if $keyword is null, other two have values
elseif ($keyword==NULL && $state_select!=NULL && $category_select!=NULL) {
//elseif ($keyword =="" && $state_select!=NULL && $category_select!=NULL) {
$query = "SELECT job.jid as id, types.t_name as name,types.color as color, job.title as title, job.company_name as company,
job.description as description, job.city as city,
job.state as state, job.post_date as created FROM job,types, categories where job.type_id = types.tid
and state = '$state_select' and job.cid = '$category_select' GROUP BY id ORDER BY created desc";
$result = mysql_query($query);
if ($result!=""){
while ($jobs = mysql_fetch_assoc($result)) {?>
<li>
<div class="type">
<span style="background:<?php echo $jobs['color']; ?>"><?php echo $jobs['name']; ?></span>
</div>
<div class="description">
<a href="details.php"><h5 id="<?php echo $jobs['id']; ?>"><?php echo $jobs['title']; ?></a>
(<?php echo $jobs['city']; ?>, <?php echo $jobs['state']; ?>)</h5>
<span id="list_date">
<?php echo date($jobs['created']); ?>
</span>
<?php echo myTruncate($jobs['description'], 200, " "); ?>
</div>
</li>
<?php
} // end while
} // end if
else {?>
<li><img src="images/noresults.jpg"></li>
<?php }
mysql_free_result($result); }?>