hi all,

can anyone suggest a good mysql forum tutorial???? I know you can get them for free but if i'm gonna learn this stuff i'd like to do it myself. I've built a small but working forum, three tables

topic table, posts table and replies table, works well enough but cant figure out how to count the number of replies for each subject in the posts page. Used two recordsets and count and i got it to work but then the repeat region killed it, been going bit daft here. I dont need a huge fancy forum, mine works but i'd just love to have the replies counted and diplayed along with the matching post.

Also i'm kinda new to this game so should i start now with PHP or go with ASP, i'm using MySQL with UD4, on a win2k machine, works great but have been thinking about PHP, would be a new challange <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Hope that all made sense

cheers in advance, Iain

Iain

www.webthang.co.uk/tutorials/gor_forum/p1.htm

www.duresources.com/resources/detail.asp?r=applications&t=UltraDev&i=475

both are UD tutorials

and both have replies in each

or download the free snitz forum software or the Php software and check out the source

forum.snitz.com
www.phpbb.com/




Edited by - biffysix on 05 Jul 2002 03:36:04

One solution to this is to use a recordset command to add 1 to a feild in your table(for instance NumOfReplies = NumOfReplies + 1) in your code every time reply form is submited.

Take a look at this tutorial:
www.udzone.com/showDetail.asp?TypeId=2&NewsId=836

Hope this Helps!

Edited by - fliquid on 07 Jul 2002 23:08:18