// // 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 "