| |
|
include "$DOCUMENT_ROOT/include/common.inc";
require "/home/httpd/reynolds/security/.mysql.info";
mysql_select_db("qpages");
if ($news_id_display):
$result = mysql_query("SELECT * FROM news WHERE id='$news_id_display' AND date_expiry>='$today' ORDER BY date_expiry");
else:
$result = mysql_query("SELECT * FROM news WHERE date_expiry>='$today' ORDER BY date_expiry");
endif;
$num_items = mysql_num_rows($result);
if ($num_items==0):
if ($news_id_display):
echo "$f3b The news id provided is invalid, Please select another news item. $xf2b | ";
else:
echo "$f3b There are no current news items to display $xf2b | ";
endif;
else:
$id = mysql_result($result,0,"id");
$heading = mysql_result($result,0,"heading");
$body = mysql_result($result,0,"body");
$photo = mysql_result($result,0,"photo");
$body = nl2br($body);
$entered = mysql_result($result,0,"date_entered");
$entered = date_convert("$entered","Y-m-d","d F Y");
$news_id_display = $id;
?>
echo $heading;?> Posted echo $entered;?> |
| echo $body;?> |
|
endif;
echo " ";
/******************************************************************************/
$result = mysql_query("SELECT * FROM news WHERE id!='$news_id_display' AND date_expiry>='$today' ORDER BY date_expiry");
$num_items = mysql_num_rows($result);
if ($num_items!=0):
echo "$f2b More Current Items:$xf2b ";
for ($i=0; $i<$num_items; $i++):
$id = mysql_result($result,$i,"id");
$heading = mysql_result($result,$i,"heading");
$body = mysql_result($result,$i,"body");
$photo = mysql_result($result,0,"photo");
$body = nl2br($body);
$entered = mysql_result($result,$i,"date_entered");
$entered = date_convert("$entered","Y-m-d","d F Y");
$news_id_display = $id;
echo "$heading - Posted $entered ";
endfor;
endif;
echo" | ";
?>
|
|
|