alex

	<?		//		//	Build index page's news articles		//		class NewsList		{			var $id			= '';			var $submitter	= '';			var $date		= '';			var $content	= '';			//construct			function NewsList()			{				mysql_connect('localhost','theadb_clansite','clansite');				mysql_select_db('theadb_clansite');							}			//grab the newest article			function GetFirstArticle()			{				$sql = mysql_query("SELECT MAX(news_id) FROM clansite_news");				while($row = mysql_fetch_array($sql))				{					$first = $row['MAX(news_id)'];					return $first;				}			}			//grab the second newest article			function GetSecondArticle()			{				$sql = mysql_query("SELECT MAX(news_id-1) FROM clansite_news)");				while($row = mysql_fetch_array($sql))				{					$second = $row['MAX(news_id-1)'];					return $second;				}			}			//grab the third newest article			function GetThirdArticle()			{				$sql = mysql_query("SELECT MAX(news_id-2) FROM clansite_news");				while($row = mysql_fetch_array($sql))				{					$third = $row['MAX(news_id-2)'];					return $third;				}			}			//build the table housing the article			function BuildTable($id)			{				$sql = mysql_query("SELECT * FROM clansite_news WHERE news_id = '$id'");				while($row = mysql_fetch_array($sql))				{					$date = $row['date'];					$submitter = $row['submitter_name'];					$content = $row['news_content'];										echo "<tr>";					echo "<td>" . $date .  " By "  . $submitter . "</td>";					echo "</tr>";					echo "<tr>";					echo "<td>" . $content . "</td>";					echo "</tr>";					echo "<tr>";					echo "<td><a href='index.php?view=".$id."'>Read More</a></td>";											}			}			//construct all three articles			function BuildPage()			{				$firstArticle = $this->GetFirstArticle();				$secondArticle = $this->GetSecondArticle();				$thirdArticle = $this->GetThirdArticle();								echo $this->BuildTable($firstArticle);				echo $this->BuildTable($secondArticle);				echo $this->BuildTable($thirdArticle);							}		}		//End NewsList Class	?>