Need a script to be able to list different categories of stock brokers.
Each broker needs to be in one or more categories.
The List of Categories:
Discount Stock Brokers
Full Service Stock Brokers
Canadian Stock Brokers
UK Stock Brokers
Penny Stock Brokers
Each broker needs to have it's own page (which is reached from the category page)
The broker category page needs to have the following fields:
Stock Broker Name
Cost per Trade
Min Account Size
Broker Assisted Trading
Average Rating (explained below)
Virtual Trading (this is just a check box)
Fields need on the individual broker page: (fields are just alphanumerical unless otherwise stated)
Stock Broker name (with a hyperlink)
Name Of company
Country of Origin
Min Account Size
Cost Per trade
Broker Assisted Trades
International Trading (check box for yes/no)
Rating (needs to have a have a drop down box between 1-10 and have a "rate it" button) Also needs to display number of votes and the average rating
The page for individual brokers needs to have a text box, where visitors can leave a review. Similar to leaving a comment on a wordpress/blogger type blog. There just needs to be a "name" and "comment" field. The reviews need to be displayed at the bottom of the page.
I need the pages to be SEO friendly. I need to be able to enter a page title, meta description and keywords. At the top of the page I need to be able to enter a title and it needs to be in <h1> tags.
The URLs needs to reflect the name of the categories and broker. For example the "discount stock brokers" category needs to be [url removed, login to view] and the same for each individual broker page. It needs to be [url removed, login to view]
If possible, I would like all the fields to be in a mysql database that I can easily edit using phpmyadmin. I do NOT require any kind of user end to the script.
An similar example of what I require can be found at [url removed, login to view]