Hmm ok ive done the new db_site->query and I couldnt find the dateline thing. But here is what I have (an excert from my index.php file)
The page still shows blank.
// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###
eval('$navbar = "' . fetch_template('navbar') . '";');
// ### news ###
$news = $DB_site->query("select thread.threadid,thread.title,thread.replycount,thr ead.postusername,thread.dateli ne,post.postid,post.pagetext from thread,post where thread.forumid=2 and post.postid=thread.firstpostid group by thread.firstpostid order by threadid desc limit 4;");
$n = 0;
while($newsitem = mysql_fetch_row($news)){
$n++;
$newstitle[$n]=$newsitem["1"];
$newsreply[$n]=$newsitem["2"];
$newsuser[$n]=$newsitem["3"];
$newsdate[$n]=vbdate("D j M Y, g:i A",$newsitem["4"]);
$newsthread[$n]=$newsitem["5"];
$limittext[$n]=parse_bbcode($newsitem["6"]);
$newstext[$n] = substr($limittext[$n], 0, 200) . "...";
$newsavatar[$n]=$newsitem["7"];
}
// ### news ###
eval('print_output("' . fetch_template('FORUMHOME') . '");');
|