Support/Comments for SMFssi

	$array = ssi_boardNews(5, null, null, null, 'array');

	foreach ($array as $news)
	{
		echo '
			<table border="0" width="100%" align="center" class="ssi_table">
				<tr>
					<td><b>', $news['subject'], '</b></td>
				</tr>
				<tr>
					<td>', $news['body'], '<br /><br /></td>
				</tr>
			</table>
			<br />';

		if (!$news['is_last'])
			echo '
			<hr width="100%" />
			<br />';
	}

SQL Query to get Post Body from News Topic Database.


SELECT `subject`, `body` FROM {$table} WHERE `ID_BOARD` ='5' ORDER BY `posterTime` DESC

____

What To Do

1. Connect to DB - Check
2. Connect to Table - Check
3. Verify connections or error out - Check
4. Query Post Results - Check
5. Query Post Titles
6. Combine Output
7. Create Final Output for Display
____

<?php
$db_host = 'localhost';  //This is the default in most cases
$db_user = 'USER';
$db_pwd = 'PASS';

$database = 'FORUM-DATABASE';  //This needs to be your SMF Database
$table = 'smf_messages'; //This should work by default unless you changed your table prefex if so modify accordingly

if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// sending query
$subject = mysql_query("SELECT `subject` FROM {$table} WHERE `ID_BOARD` ='5' ORDER BY `posterTime` DESC");
if (!$subject) {
    die("Failed to get Subject");
}
$body = mysql_query("SELECT `body` FROM {$table} WHERE `ID_BOARD` ='5' ORDER BY `posterTime` DESC");
if (!$body) {
    die("Failed to get Body");
}

$sub = mysql_num_fields($subject);
$bod = mysql_num_fields($body);

// printing table rows
while($row = mysql_fetch_row($result))
{
    echo "<tr>";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
        echo "
		<p>
		$cell
		</p>
		<hr class='divider' />";

    echo "</tr>\n";
}
mysql_free_result($result);
?>

//////////   Current SSI Customization - Target Formating  //////////

	<h1><img src='images/ill_title.jpg' alt='ill title' width='63' height='20' />', $news['subject'], '</h1>
	<p>', $news['body'], '</p>
	<hr class="divider" />