Website Integration - SSI?

Hi, I'm wondering if there's a script available or can be written that will allow the last x guestbook entries be viewed on another webpage. Like the Invision Power Board uses the SSI to view the last x posts.

Any help will be appreciated

Thanks

I did write a script for someone that pulls the last five entries and displays them. I can try and dig it up.

That would be great and much appreciated.

Thanks

I was going to upload it somewhere but I'll just post it in here for you to copy and paste. Just put the file in the guestbook folder then include it where you want the entries to be displayed.

<?php

//
// Put in some error handling
//

ini_set('display_errors', 1);
error_reporting(E_ALL & ~E_NOTICE);

//
// Include the config file to get the database settings
//

include "admin/config.inc.php";

//
// Connect to MySQL server and select database if possible
//

if ($dbc = @mysql_connect ($GB_DB['host'] , $GB_DB['user'] , $GB_DB['pass'] ))
{
	if (!@mysql_select_db ($GB_DB['dbName']))
	{
		die ('<p>Could not select the database because: <b>'.mysql_error().'</b></p>');
	}
} 
else 
{
	die ('<p>Could not connect to MySQL because: <b>'.mysql_error().'</b></p>');
}

//
// Here we put any HTML that goes before our entries
//

print "<table>
";

//
// Run our MySQL query
//

$r = @mysql_query('SELECT * FROM '.$GB_TBL["data"].' ORDER BY id DESC LIMIT 5');

//
// Turn the results into an array and go through the array formatting each entry
//

while ($lentry = mysql_fetch_array($r))
{
	$ldate = date("l jS F Y", $lentry['date']);
	print "<tr>
	<td>Name:</td>
	<td>$lentry['name']</td>
	</tr>
	<tr>
	<td>Posted:</td>
	<td>$ldate</td>
	</tr>
	<tr>
	<td>Message:</td>
	<td>$lentry['comment']</td>
	</tr>
	";
}

//
// Here goes any HTML for after the entries
//

print "</table>";

//
// Close the MySQL connection
//

mysql_close();
?>

thanks very much.

You can change the date format if you know PHP date code and the number of entries in the query. Can you let me see it in action ?

After the code include .. I receive these kind of errors

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/username/public_html/book/latest.php on line 54

It means you have an error on line 54.

I just copied your instruction code .. so what's that error ?

JohnnyUSA wrote:I just copied your instruction code .. so what's that error ?

T_ENCAPSED_AND_WHITESPACE

Line 54 is

<td>$lentry['name']</td>

Can't see a reason for th eerror.

Could you please check the code again? to make sure it work right ?

The print on two lines maybe?

Anyway, post what you have on line 54.

Ah the wanderer returns.

Something is really wrong with the Line: 54 <td>$lentry['name']</td> and Line: 61 <td>$lentry['comment']</td>

After I remove those 2 out, the display seem like work without error, but what is the right code for entry comment and name?