Include News content on main page

Thanks Jason. I need to change my username to "not-thinkng"

I'm clueless on how to utilize this info and the index page. Could you possibly post the code as how the page would function?

Also, is it possible to limit the text that is shown from the News, to a max number of words, then click to read the whole story?

Thanks



<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php


// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/content/52/7231752/html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records
list($main_pageRecords, $main_pageMetaData) = getRecords(array(
'tableName' => 'main_page',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$main_pageRecord = @$main_pageRecords[0]; // get first record

// show error message if no matching record is found
if (!$main_pageRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}

list($newsRecords,$newsMetaData)=getRecords(array(
'tableName' => 'news'
'allowSearch' => false,
'orderBy' => "createdDate DESC",
'limit' => 2,
));

?>
<h1>Main Page</h1>
<p>Record Number: <?php echo $main_pageRecord['num'] ?><br/>
Title: <?php echo $main_pageRecord['title'] ?><br/>
Content: <?php echo $main_pageRecord['content'] ?><br/>
</p>

$leftNewsBox=array();
$rightNewsBox=array();

$leftNewsBox = @$newsRecords[0];
$rightNewsBox = @$newsRecords[1];

<?php if($leftNewsBox):?>
*OUTPUT LEFT BOX NEWS RECORD*
<?php endif ?>

<?php if($rightNewsBox):?>
*OUTPUT RIGHT BOX NEWS RECORD*
<?php endif ?>



<div align="center">
<table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%"><div align="center"> <br>
<table width="250" border="2" cellspacing="0" cellpadding="5" bgcolor="white" bordercolor="#629371">
<tr>
<td>content in this box <a href="#">continue</a></td>
</tr>
</table>
<br>
</div></td>
<td width="50%"><div align="center"> <br>
<table width="250" border="2" cellspacing="0" cellpadding="5" bgcolor="white" bordercolor="#629371">
<tr>
<td>content in this box <a href="#">continue</a></td>
</tr>
</table>
<br>
</div></td>
</tr>
</table>
</div>



<?php if (!$main_pageRecord): ?>
No record found!<br/>
<br/>
<?php endif ?>