boardom

[JagEsquire]

Hi there everyone, thank you all for all the help you have silently provided me. But I have finally run into a difficulty that hasn't been answered here in the discussion forum.

I borrowed a hack from GamerZ that he posted here. And I've played with it a bit to make it look like I want it to. Here is a sample of what I have running.

[mikelittle]

Ho JaqEsquire,

Try this (note: I've reformatted for clarity)
[php:1:4338136254]
<?php
dbconnect();
$result = mysql_query("select ID, DATE_FORMAT(post_date, '%d.%m.%Y'), post_title, " .
" count(comment_ID) as comment_count " .
" FROM b2posts LEFT JOIN b2comments on comment_post_ID = ID " .
" GROUP BY ID " .
" ORDER BY post_date DESC LIMIT 36");
while(list($ID, $date, $title, $comment_count) = mysql_fetch_row($result)) {
$comment_text = (($comment_count == 0) ? "no comments" : (($comment_count > 1) ? "$comment_count comments" : "1 comment"));
?>
<div align="center">
<a href="tsmokeblog.php?p=<?= $ID ?>"><font face="verdana" size="4"><?=$title?></a><br/></font>
</div>
<div align="center">
<font face="verdana" size="1">posted on <?=$date?> (<?=$comment_text?>)</font>
</div>
<hr width="60%"/>
<?php
}
?>
[/php:1:4338136254]

Hope this helps,

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

[JagEsquire]

It's perfect, beautifull.

I was begining to lose hope. I watched each day as new posts bumped mine off the top of the page, and was tempted on ocation to go in and read my own post to up the number of views to create interest, or maybe post to myself and raise its level on the page.

I'm glad my online morals held me back. I'm glad there are people like you willing to spend the time to help.

I'll have a few faces to rub on this one tomorrow. A couple of guys from work took a look and convinced me that I would have to write a new function to make this work. You've proved your genious over them (and me).

Thank You very much for your time and effort.

JagEsquire