Suggestions for Comments and a Club Directory

jonwade

I am new to PHP and web design in general. I want to add two things to my site:

Firstly, I want a simple comments field, with email moderation, that can be placed onto any page. I guess I need to set up a MySQL database to do this all. (like you get on blogs etc). Ideally with automatic spam filters of some kind - or nauthy word filters.

Secondly, I am planning to set up a simple directory of sports clubs, with the option for anyone to submit a listing - also with moderation, and with no URL (it will be a simple club name, address, and contact name and telephone number).

So, can anyone recommend any open source products that will allow me to do these things? I had great plans to learn it all myself, but I am really struggling to find the time to read my php book! So maybe using something already built is the way ahead.

Is there a way to set up comments without a database? e.g. something with FTP that will upload a new file that can then be read via an include or something? Or is Mysql really the only way to go? My web host seems very flexible, but they do not provide much in the way of software support (at least not for what I need - they have a guestbook, but not a page by page comments feature).

Cheers,

Jon.

jonwade

Hello

Please could someone point me in the right direction. I looked at the product that Halscan provide, but as you have to pay to use it I want to create my own.

It seems that it should be quite straightfoward, with just some scripts on the page to link to a database - so I think I should be able to implement something - I just need to find a simple tutorial for adding comments to a page using php and mysql.

I will search google again, but if someone knows of something that would be ideal, please let me know,

Cheers,

Jon.