Latest posts for the topic "How to retrieve latest comments in advacned guestbook 2.3.1"

How to retrieve latest comments in advacned guestbook 2.3.1

Anonymous — GMT

Could someone help me to retrieve the latest comments in the guestbook for my main page. All I need just to display the latest comments and the date and time and name of the person who write the comment.

I'm new to this guestbook and also newbie to PHP / WEB.

Thank you,

Ken

Carbonize — GMT

Ok I hassled Freddy and he threw together the following:
[code]
include('guestbook/admin/config.inc.php');

mysql_connect($GB_DB['host'],$GB_DB['user'],$GB_DB['pass']);
mysql_select_db($GB_DB['dbName']);

$numberOfComments = 5;

$query = "SELECT name,comment,date
FROM ".$GB_TBL['data']."
ORDER BY id DESC
LIMIT 0,$numberOfComments";

$result = mysql_query($query);

$templateFile = 'guestbook/templates/selective.txt';
$templateFP = fopen($templateFile,'r');
$template = fread($templateFP,filesize($templateFile));
fclose($templateFP);

while($comment=mysql_fetch_array($result,MYSQL_ASSOC)) {
eval("\$output .= \"".$template."\";");
}

echo $output;

?>[/code]

Anonymous — GMT

Hi There,

I use your code to put it in my website, bust somehow it didn't display anything to the page. I want to display the 1 column 5 rows of the latest comments, but somehow display nothing. Please help me out.

THank you,

Nhan

Anonymous — GMT

Nice one, but what do you add in this file

guestbook/templates/selective.txt

As I see the script needs it.

$templateFile = 'guestbook/templates/selective.txt';

Carbonize — GMT

Yes I'm trying to get hold of Freddy to see what thats all about.

Carbonize — GMT

Selective text is a template for how you want it to appear. Do not place it between php tags.

[quote]selective.txt would contain $comment[name] and $comment[comment] in it
where they should be displayed.[/quote]

Anonymous — GMT

Carbonize,

some how this script don't get the database comments and store in selective.txt.

thanks

Carbonize — GMT

selective.txt is just a template.

[quote]

$comment[name]

$comment[comment]

[/quote]

Thats an example of what selective.txt should contain.

Anonymous — GMT

Thanks Carbon

Khang

Anonymous — GMT

carbonie,

when I get the $comment[date] it gives me 1094754924 this...what is it? How can I get the date of the comment?

THanks

Carbonize — GMT

The date is stored as a unix timestamp. I'll rewrite the script to allow the timestamp to be formatted when I get chance.

Anonymous — GMT

THanks in advance Carbonie. I really need to have this done ASAP.

THanks again,

Khang

Carbonize — GMT

Try [code]while($comment=mysql_fetch_array($result,MYSQL_ASSOC)) {
$posted = date("H:m:s", $comment[date]);
eval("\$output .= \"".$template."\";");
} [/code]
Then use [b]$posted[/b] in the template instead of [b]$comment[date][/b]. You can learn more about the syntax of the [b]date()[/b] function as well as what the letters represent at www.php.net/date

It took me a while to reply as I was busy with a paying customer who had messed up his tables.