i need some advice

[razzle]

well really a point in the right direction

 

basically im trying to implement a new function on my site

 

my site is the base for my podcast, and i archive all my shows on individual pages within the site

 

check out my site http://www.pushmusic.org and click the archive tab to see what i mean

 

now what i really need is a form so that people can leave feedback on that page about that particular podcast, and i want it to be displayed on the page too, similar to a forum style post i suppose.

 

now ive looked about for some tutorials and guides but i have no idea what this is called

 

can someone tell me / show me how its done?

 

many thanks

 

ben

[pocobueno1388]

Here is how your table structure would need to be

 

-------------------------------------------------
TABLE podcasts [this table should already be made]
--------------------------------------------------
podcastID
other_info
...
...

-----------------
TABLE comments
-----------------
commentID
podcastID [the ID of the podcast from the "podcasts" table]
body [the actual comment/feedback]

 

Here are some tutorials for help with the coding

http://www.zimmertech.com/tutorials/php/25/comment-form-script-tutorial.php

http://www.codewalkers.com/c/a/Database-Articles/PHPMySQL-News-with-Comments/

http://www.dmxzone.com/ShowDetail.asp?NewsId=5990

 

And there is much more on google if you type in "PHP comment system tutorial".

[razzle]

you are a top man

[centerwork]

I would recomend downloading the PHP & MYSQL Video Training from the link below. It is free and gives a lot of good informtion that you need for working with any PHP & mysql.

 

http://www.3dbuzz.com/vbforum/sv_dl_tr.php

 

Create a login and then click on "PHP & MySQL Integration".

 

There is a complete section on creating a guestbook which you could easily modify for a forum.