Hi, I have this code query and I dont seem to be able to display time. It only show me the latest post title but not time.
I want something like that. "ABCBD title, Today, 11.02am". Can anyone advise what is wrong with this queries? Thanks.
//Latest post
$post_get = vB::$db->query_read("
SELECT * FROM ".TABLE_PREFIX."post p, ".TABLE_PREFIX."thread th
WHERE th.threadid = p.threadid AND forumid NOT IN (28,29) ORDER BY p.postid DESC
LIMIT 20");
//Latest post
$output_bits .='<div id="tab-4" class="tab-content document"><div class="document"><ul>';
while($post = vB::$db->fetch_array($post_get))
{
$i++;
if($i%2 != 0) $cl ='li-1'; else $cl ='li-2';
$output_bits .= '<li class="'.$cl.'">'.$post[title].' ' .$post[time].' <a rel="nofollow" href="showthread.php?goto=newpost&t='.$post[threadid].'"> read post ยป</a></li>';
I want something like that. "ABCBD title, Today, 11.02am". Can anyone advise what is wrong with this queries? Thanks.
//Latest post
$post_get = vB::$db->query_read("
SELECT * FROM ".TABLE_PREFIX."post p, ".TABLE_PREFIX."thread th
WHERE th.threadid = p.threadid AND forumid NOT IN (28,29) ORDER BY p.postid DESC
LIMIT 20");
//Latest post
$output_bits .='<div id="tab-4" class="tab-content document"><div class="document"><ul>';
while($post = vB::$db->fetch_array($post_get))
{
$i++;
if($i%2 != 0) $cl ='li-1'; else $cl ='li-2';
$output_bits .= '<li class="'.$cl.'">'.$post[title].' ' .$post[time].' <a rel="nofollow" href="showthread.php?goto=newpost&t='.$post[threadid].'"> read post ยป</a></li>';
Comment