|
| |
| |
prepare($sql);
$rs->execute();
$rows = $rs->fetch(PDO::FETCH_BOTH);
$all = $rows[0];
$start = (($p * $limit) - $limit);
$sql = "SELECT * FROM tb_news WHERE ns_visible='1' ORDER BY ns_id DESC LIMIT ".$start.", ".$limit;
foreach($dbh->query($sql) as $row)
{
if($row["ns_style"] == "link")
{
$link = $row["ns_link"];
$icon = " ";
}
else if($row["ns_style"] == "file")
{
$link = "news/".$row["ns_link"];
$icon = " ";
} else {
$link = "news.php?id=".$row["ns_id"];
$icon = "";
}
$strTitle = $row["ns_title"];
if(strlen($strTitle) > 150) $strTitle = substr($strTitle, 0, 150);
echo $icon.' '.$strTitle.'  [ '.substr($row["ns_date"], 0, 10).' ]
';
}
}
else
{
include("msg.php");
}
?> |
| |
|
|
|
