| 47 |
$sql_where.=" and id=$id "; |
$sql_where.=" and id=$id "; |
| 48 |
} |
} |
| 49 |
|
|
| 50 |
$sth = $dbh->prepare("select id,upper(title) as title,town_date,body,more,pdf from news $sql_where order by date 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); |
Parent Directory
| 
Revision Log
| 
Patch