Thanks a bunch.
I ran across this though after doing the above. Sorry to be a bother, still relatively new to php.
Code:
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT thread.threadid, replycount, postusername, postuserid, thread.dateline AS postdateline,
thread.forumid, forum.title as title, forum.fhbanner as icon, post.postid, pagetext, allowsmilie
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.dateline>UNIX_TIMESTAMP(CURDATE()) AND thread.forumid IN(45,46,42,43,44)
AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL
GROUP BY post.postid
ORDER BY forum.displayorder
mysql error: Column: 'replycount' in field list is ambiguous
mysql error number: 1052
Date: Thursday 28th of October 2004 04:52:27 AM
Script: http://www.ahazi.org/forums/showthread.php?p=53981
Referer: http://www.ahazi.org/forums/editpost.php?do=editpost&p=53981