will
Posts: 88
|
| Posted: 04/07/2008, 1:21 PM |
|
ok I am trying to wrap my head around this one I have a label and on it i have before show event now this works great with 1 flaw after about 4 posts it stops updating the date
$db = new clsDBlocalhost();
$last_post_date = CCDLookUp("MAX(date_add)","forum_posts","topic_id=".$topics->topic_id->GetValue(),$db);
$last_parent_post_date = CCDLookUp("MAX(date_add)","forum_topics","topic_id=".$topics->topic_id->GetValue(),$db);
if ($last_post_date) {
$topics->last_activity->SetText($last_post_date);
} else {
$topics->last_activity->SetText($last_parent_post_date);
}
|
 |
 |
|
