INSERT INTO `messageboard` ( `name` , `message`,`topic`,`messagedate`) values ('#name#','#message#','#topic#',#now()#) select distinct topic, name, DATE_FORMAT(max(messagedate),'%W %M %D %Y') messagedate, count(topic) numofmess from `messageboard` group by `topic` order by `messagedate` desc select distinct topic, message, name, DATE_FORMAT(messagedate,'%M %D %Y') messagedate from `messageboard` where `topic` = "#vtopic#" order by `messagedate` desc

#topic#
#message#
#name#	#messagedate#
Name:
Message:
Name:
Topic:
Message:
Topic	Name	Date Posted
#topic#	#name#	#messagedate#
#message#
Add Your Comment Here
Name:
Message:
Welcome to the Springfield Inn Message Board
The usual rules apply. Please keep profanity down to a minimum and refrain from bad-mouthing the other bars in town or the employees of the Springfield Inn. Instructions: To post a new topic, click the Post New Button (Duh!) To reply to an existing message, click the topic to see the expanded view. You will be able to reply there. Have Fun!
Topic	Name	Date Posted	Number of Messages
#topic#	#name#	#messagedate#	#numofmess#