Location: PHPKode > projects > Basic Announce > Basic Announce Version 4.0/pages/news.php
<?php 
include '../inc/config.inc.php';
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-GB">

  <head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta http-equiv="Content-Language" content="en-GB" />
    <meta name="author" content="Bull Web Host & Basic Announce" />
    <meta name="abstract" content="A one-liner describing your site." />
    <meta name="description" content="A longer description of your site." />
    <meta name="keywords" content="some, words, characterising, your, web, site" />
    <meta name="distribution" content="global" />
    <meta name="revisit-after" content="1 days" />
    <meta name="copyright" content="All content (c) Bull Web Host & Basic Announce" />

    <title>News!</title>

    <style type="text/css" title="The shiny, Web 2.0 version of 'Simplicity,' a pseudo-professional style-sheet." media="all">
      @import "layout/simplicity.css";
    </style>
     <!--[if lte IE 7]>
    <style type="text/css" media="all">
      @import "layout/ie-diff.css";
    </style>
    <![endif]-->

    <link rel="stylesheet" type="text/css" href="layout/print.css" media="print" />
    <link rel="shortcut icon" href="http://wherever-your-favicon-is.org/favicon.png"  />
    <link rel="icon" href="http://wherever-your-favicon-is.org/favicon.png" />

  </head>

  <body>

    <div id="window">
      <div id="container">

	<div id="navigation">
	  <? /* <ul>
	   <!-- The link you call "active" will show up as a darker tab -->
	    <!--[if IE 6]><li></li><![endif]-->
	    <li><a href="index.html">Showcase</a></li>
	    <li class="active"><span>Journal</span></li>
	    <li><a href="index.html">Artistry</a></li>
	    <li><a href="index.html">Projects</a></li>
	    <li><a href="index.html">Feeds</a></li>
	    <li><a href="index.html">Explore</a></li>
	  </ul> */ ?>
	</div>

	<div id="main">
	  <div id="outer-prettification">
	    <div id="inner-prettification">

	      <div id="header">
		<h1 id="title"><a href="news.php">Latest News!</a></h1>
	      </div>

	      <div id="contents">
        <p><?php

// Connects to your Database

mysql_connect("$server","$usr","$pswd") or die(mysql_error());

mysql_select_db("$db") or die(mysql_error());

$data = mysql_query("SELECT * FROM announcements")

or die(mysql_error());



while($info = mysql_fetch_array( $data ))

{

Print "<tr>";

Print "<th>Announcement:</th><td>".$info['Announcement'] . "</td> ";

Print "<br>";

Print "<th>Submitted By:</th> <td>".$info['Submitted'] . "</td> ";

}

;

?> </p>       
	      </div>     

              <div id="footer">
		<p><a href="" title="Basic Announce"> &copy; Bull Web Host & Basic Announce</a></p>
		<!-- You can do whatever you like here -->
	      </div>

	    </div>
	  </div>
	</div>

      </div>
    </div>

  </body>

</html>
Return current item: Basic Announce