Discussion Group

[gasser]

I'm trying to build a message board using asp
can any one give me aprogramming model
Any Ideas or samples ?

------------------
Gasser (CesaR)

[HarryW]

I've been wondering how to do it myself. I guess it's textareas and lots of tables and a big database. But more complicated, obviously :)

I expect it's fairly easy to do one that doesn't look so hot, but for a nice pretty one like this it's probably difficult.

[smalig]

Simply you can use only one table like follow sample:

ID
ParentID
Title
Message
Date

When user posted a new topic you should be insert the record:

1, 0, "New Topic", "Hello, World!", "01/01/00"

Here's the answer to new topic:

2, 1, "Replay", "Re: Hello, World!", "02/01/00"

And display the main topics by using the result of statement.

SELECT * FROM table WHERE parentid=0 ORDER BY date DESC

For answers use "WHERE parentid=XXX".

Best regards.

------------------
smalig
smalig@hotmail.com
http://vbcode.webhostme.com/

[smalig]

Here is the source code of ASP based forum
with live demo.
http://asp.superexpert.com/code/code.asp?codeid=23

Best regards.

------------------
smalig
smalig@hotmail.com
http://vbcode.webhostme.com/