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
|
<?php
//#5.3#//if ($p_status_news_tender_out != "") { $status_news_tender_out = trim($p_status_news_tender_out);}
$status_news_tender_out = isset($p_status_news_tender_out) ? $p_status_news_tender_out : '';
//#5.3#//if ($p_id_deles != "") { $id_deles = trim($p_id_deles); }
$id_deles = isset($p_id_deles) ? $p_id_deles : '';
fieldset_top("ข่าวจัดซื้อจัดจ้าง");
$date = date("d");
$month = date("m");
$year = date("Y");
$yearthai = $year + 543;
$datenow = $yearthai . $month . $date;
// #############################ข่าวจัดซื้อจัดจ้างภายนอก##########################
include('coremain/connec_out.php');
// Delete News
if ($id_deles != "") {
$sql = "delete from cms_news_tender where id='$id_deles' and id_tumbon='$_SESSION[id_tumbon]'";
$result = mysql_query($sql) or die(mysql_error());
}
//if ($x[0] == 1) {
//$query="select id,LEFT(topic, 200) as topic,date_post,status from cms_news_tender WHERE status='1' order by id desc Limit 5";
$query = "select id,LEFT(topic,200) as topic,date_post,status,id_tumbon from cms_news_tender WHERE status='1' and show_on_off!='1' and (show_on_off='3' OR province='$_SESSION[name_province]') order by orders desc Limit 10";
?>
<table width='100%' align='right' cellpadding='1' cellspacing='1' bgcolor='<?= $_SESSION['tb_head_bgcolor'] ?>'>
<?php
$result = mysql_query($query);
$count = 0;
while ($data = mysql_fetch_array($result)) {
if ($count % 2 == 0)
$bg = "eeeeee";
else
$bg = "ffffff";
?>
<tr height='25' bgcolor='<?= $bg ?>'>
<td>
<img src='coremain/images/marker.gif'>
<a href='index.php?mod=news_tender_full&path=news_tender_out&id_tender=<?= $data['id'] ?>&id_tumbon=<?= $data['id_tumbon'] ?>'><?= $data['topic'] ?></a>
</td>
</tr>
<?php
$count++;
}
// ####################### ข้อมูลย้อนหลัง
if ($count >= "5") {
?>
<tr bgcolor=<?= $_SESSION['tb_head_bgcolor'] ?>>
<td align=center>
<img src='coremain/images/arrow.gif' border='0'>
<a href='index.php?mod=news_tender_old&path=news_tender_out'>ข่าวย้อนหลัง</a>
</td>
</tr>
<?php } ?>
</table>
<?php
//}
mysql_close($handle_out);
include("$_SESSION[web_name]/connect.php");
fieldset_down();
?>
|