select_row(“SELECT count(id) as count FROM forums WHERE topic=’0′ “.$keywordQRY.””);
$total = $totalItems[‘count’];
$perPage = 23;
$pages = ceil($total/$perPage);
$curPage = 0;
if(isset($_GET[‘page’]) && $_GET[‘page’] !=””){
$curPage = addslashes((int)$_GET[‘page’] – 1);
}
// Make sure selected page is valid
$curPage = $curPage >= $pages ? $pages – 1 : ($curPage <= 0 ? 0 : $curPage);
//print "page: ". $curPage;
$curRecordStart = ($curPage * $perPage); //perpage*page (limit is NOT inclusive)
//print "Start " . $curRecordStart;
$items = NULL;
//$qry1 = "SELECT forums.id, forums.member, forums.name, forums.title, forums.posted, forums.topic_views, forums.topic_replies, //DATE_FORMAT(forums.topic_posted, '%M %D, %Y @ %H:%i') AS topic_posted_format, members.username FROM forums, members WHERE //forums.member=members.id AND forums.topic='0' ".$keywordQRY." ORDER BY forums.topic_posted DESC LIMIT ".$curRecordStart.", //".$perPage."";
$qry1 = "SELECT
forums.id,
forums.topic,
forums.member,
forums.name,
forums.title,
forums.posted,
forums.topic_views,
forums.topic_replies,
DATE_FORMAT(forums.topic_posted, '%M %D, %Y @ %H:%i') AS topic_posted_format,
members.username
FROM forums LEFT OUTER JOIN members
ON forums.member = members.id " . $keywordQRY . "
WHERE topic = 0
ORDER BY forums.topic_posted DESC
LIMIT " . $curRecordStart . ", " . $perPage;
$items = $MySQL->select_all($qry1);
?>
This
|
Security Notice: The Pentagon OPSEC working group has released a brochure for DoD personnel and their families. The brochure underlines the importance of OPSEC while publishing a list of what to do and what not to do regarding Internet safety. The brochure advises all DoD personnel and families actively posting material on the web to consult supervisors or security or OPSEC managers if they’re not sure if information is sensitive. Posting information about upcoming deployments, a family member’s unit or location, and hometown addresses might seriously threaten the lives of DoD personnel and their families. The brochure can be obtained by visiting the Army Knowledge Online Website at https://www.us.army.mil. |
|
Topic | Views | Replies | Started By | Last Post | “. $row[‘title’] .” | ‘ . $row[‘title’] . ‘ | “. $row[‘topic_views’] .” | “. $row[‘topic_replies’] .” | “. $row[‘username’] .” | “. $row[‘name’] .” | “. $row[‘topic_posted_format’] .” |
0){ print “Previous Page \n”; } print “Page “. ($curPage+1) .” of “. $pages; if($curPage+1 < $pages){ print " Next Page\n”; }*/ if ($curPage > 0) { /* echo ‘ << First Page */ echo ‘< Previous Page‘; } else { //echo ‘<< First Page //echo ‘< Previous Page ‘; } echo ‘Next Page >‘;// // Last Page >>‘; } else { //echo ‘ Next Page >’;// Last Page >>‘; } ?> |
Directions:
· All times are in military time.
· Click on any message title to view it.
· To reply to a message: Click on “Reply”
· To begin a new topic thread: Click on "Post New Topic"
· Obscenities are prohibited on this military message board and will be removed immediately.
· People outside the military are allowed to post on this military message board.
This message board is monitored daily.