boardom

[.Chris]

I kind of modified this to show the post titles also..

[daisha]

hello. i was wondering if there is anyway that rather than having the subject and date, that you could have it show the author of the post and maybe a potion of the comment and have a link going to the comments area so you can get the rest of what they posted in the comments?

am i making sense????

[Mister44]

[JEDOK]

I've found a strange problem

When i include last5Comments.php before the b2 loop, the whole b2 loop seems to be ignored. Everything is ok but only the lines within b2 loop doesn't show up in the browser. Last 5 comments are listed fine, but i can't see my posts at all.

yeah, when i put <?php include(last5Comments); ?> after the end of the b2 loop, then everyting works fine, and i can see the posts too.

mmm... is there any answer???

[mikelittle]

This is because it is using a variable called $result, which is also setup by blog.header.php and used by the main loop.
When you include this hack it wipes out $result for the main loop.


Hope this helps,

Mike
_________________
Mike Little
http://zed1.com/b2/
"Share what you know. Learn what you don't."

[JEDOK]

Thanks, Mike. Now the problem is not a "strange" thing....

But ... you mean that there is no way to see the last 5 comments before the main posts?

[dtdgoomba]

In that hack, just rename all instances of $result to something else, like $comresult. I do that for all my hacks so they'll work

[mikelittle]

It's not a problem to see the last 5 comments before the main loop.
The thing to do is stick the code into a function (which takes the variables out of scope of the main script) and call the function wherever you want.

Try this:

[JEDOK]

Thank you~! finally it works fine.

I think using it as a function is better than the original one.

(well, I know nothing about PHP, though.. hehe)

[dtdgoomba]

Nice Mike. Since I wasn't a comp sci guy in school, I totally forgot about 'scope' and global variables, etc that my roommate has been trying to teach me in previous cases. Keep up the good work

[wteening]

How would I create a function from the following?

<?php include("b2config.php"); ?>
<p>
<?php
$d4 = mysql_connect("$dbhost", "$dbusername", "$dbpassword");
mysql_select_db("$dbname",$d4);

$sql="SELECT comment_post_ID,comment_author, post_title FROM $tablecomments, $tableposts WHERE comment_post_ID=ID ORDER BY comment_date DESC LIMIT 4";
$result=mysql_query($sql,$d4);

$num = mysql_num_rows($result);
$cur = 1;

// Loop-dee-loop to display last 5 records
while ($num >= $cur) {

$row = mysql_fetch_array($result);

$comment_post_ID = $row["comment_post_ID"];
$comment_author = $row["comment_author"];
$post_title = $row["post_title"];

if (strlen($comment_author)>10){
$comment_author=substr($comment_author,0,."..";
}
if (strlen($post_title)>1{
$post_title=substr($post_title,0,16)."..";
}

// Display each record
echo "<tr><td><a href=\"index.php?p=$comment_post_ID&c=1#comments\">$comment_author: </a></td><td><a href=\"index.php?p=$comment_post_ID&c=1#comments\">$post_title</a></td></tr>";

$cur++;
}
?>

[mikelittle]

OK, try this...

[wteening]

Thanks! It works! I had to remove a space in the second part though:
<?php instead of <? php
For the people as dumb as me.

Check out the result:

http://www.krabbels.com

[mikelittle]

Great! I'm glad to hear it.
I've fixed the space now.

Mike
_________________
Mike Little
http://zed1.com/b2/
"Share what you know. Learn what you don't."

[Aredubya]

Hi folks,

I recently installed this hack on my b2-run site (http://blog.netho.net), and so far, it's working great. I did make one adjustment to the date/timestamp query some of y'all might find useful. I replaced it like so: