Music Review site

[Dopple]

I'm getting involved with a music reviewing site and the guy who runs it was asking me if there's a way that he can have input fields that the reviewers would be able to use and for the review to show up but I'd only want the reviewers to be able to see the input fields. Would sending the data from the input fields to a java script doc be the best way to do this? Then on the bands page it would call for the data on each of the seperate JS docs? If anyone can think of a better way to do this I would be very appreciative top hear their comments.

[ffurnai]

I think that submitting the form data to a database is probably your best bet. PHP and MySQL are a good combination.

by storing the info in a db you can call it again at any later date.

[PeOfEo]

see what server side languages your server supports and what data bases it supports. Do you have any programming experience other than markup (html and css), things like c, c++, vb, or java?

[Dopple]

Unfortunatly not. I am willing to learn though. Although if it's going to be too much trouble I might just tell the guy to get the reviewers to email the reviews to him.

[ffurnai]

This sounds like it wouldn't be that difficult to do even a pretty basic db with the reviews and a form to enter them. I'd check to see what your server (host) supports/provides and then let us know. I'm pretty sure that you can find any help you need (troubleshooting, where to begin, etc.) right here.

Ian

[Dopple]

Ok, so..... The web host is a free one called freeownhost.com and it supports MYSQL and PHP. Now I am wondering where to start with this. Should I start out with a basic form? or should I set up the SQL and PHP first. This is the first time I've used either but once I've had a play around with them I should be fine. Just wondering about a starting point. Thanks.

[ffurnai]

I'd probably start with the SQL db first. Set it up so that it has all the appropriate columns (artist, album, review, reviewer, date, etc, etc). Then set up the form to make sure that it posts the data.

As you get to the PHP stuff you can keep posting here but then it might be appropriate to move this to the PHP forum.

ask back with any questions. I'm no PHP/SQL guru but have done similar stuff to this and might be able to help.