47 |
$sql_where.=" and id=$id "; |
$sql_where.=" and id=$id "; |
48 |
} |
} |
49 |
|
|
50 |
$sth = $dbh->prepare("select id,title,town_date,body,more,pdf from news $sql_where order by id desc"); |
if (isset($type)) { |
51 |
|
if ($type == "n") { |
52 |
|
$sql_where .= " and type='n'"; |
53 |
|
} |
54 |
|
} |
55 |
|
|
56 |
|
if (! isset($show) && !isset($start)) { |
57 |
|
$sql_limit="limit 10"; |
58 |
|
} elseif (isset($start)) { |
59 |
|
$sql_limit="limit 10,$start"; |
60 |
|
} |
61 |
|
|
62 |
|
|
63 |
|
$num_selected=0; |
64 |
|
$sql="select |
65 |
|
id,upper(title) as title,town_date,body,more,pdf, |
66 |
|
(date-now()::date) as comming |
67 |
|
from news $sql_where order by date desc $sql_limit"; |
68 |
|
# print "$sql"; |
69 |
|
$sth = $dbh->prepare("$sql"); |
70 |
$sth->execute(); |
$sth->execute(); |
71 |
while ($row=$sth->fetchrow_hash()) { |
while ($row=$sth->fetchrow_hash()) { |
72 |
$data[]=$row; |
$data[]=$row; |
73 |
|
$num_selected++; |
74 |
|
} |
75 |
|
|
76 |
|
if ($num_selected == 10) { |
77 |
|
$smarty->assign(array( |
78 |
|
"multi_page_show" => 1, |
79 |
|
"multi_page_next" => "$PHP_SELF?start=".($start+10), |
80 |
|
)); |
81 |
|
} |
82 |
|
if ($start && $start >= 10) { |
83 |
|
$smarty->assign(array( |
84 |
|
"multi_page_show" => 1, |
85 |
|
"multi_page_prev" => "$PHP_SELF?start=".($start-10), |
86 |
|
)); |
87 |
} |
} |
88 |
|
|
89 |
$smarty->assign("data",$data); |
$smarty->assign("data",$data); |