$date_today=date("Y-m-d");
if (empty($id)) {
$strsql=sprintf("select * from tbnews where idgroup='%s' and date<='%s' and status='%s' order by date desc limit 1",
mysql_real_escape_string($idgroup),
mysql_real_escape_string($date_today),
mysql_real_escape_string("Y"));
} else {
$strsql=sprintf("select * from tbnews where idnews='%s' and idgroup='%s' and date<='%s' and status='%s' ",
mysql_real_escape_string($id),
mysql_real_escape_string($idgroup),
mysql_real_escape_string($date_today),
mysql_real_escape_string("Y"));
}
$result=mysql_query($strsql);
$rs=mysql_fetch_array($result);
if (!empty($rs[idnews])) {
?>
|