This is a project requiring the improvement of a small mysql database and the display of the data on a website, possible link with Wordpress site
I need the ability to add data using a form to the following tables: county, facility, region, route, country These will be used by staff only and will be in a protected directory on the final site I need the database revised to be the most approriate type for the use and the tables and fields to be reviewed and changed to ensure they are the best type for indexing etc I need a way to search for a route using the following criteria: country_id, county_id, region_id, difficulty_id, distance_id, route_id The data is to be displayed on a webpage using tabs to move between the data, tab 1 will be a map which I have a flash animation file for tab 2 will be a summary of various fields from the routes tbl tab 3 will be pictures which need to be stored in a directory (should we have fields for picture file names?) Tab 4 will be downloads which will be stored like pictures (again I need to know how they should be stored/referenced) I want the user to have the ability to leave comments on the route in TAB 5, the user data should be received from the Wordpress table which will form the main section of the site External websites should be able to link to the page with the tabs using variables which will determine either the route to be displayed or the county_id THE DISPLAY PAGE FOR THE DATA MUST BE ABLE TO BE INTEGRATED INTO 3RD PARTY SITES IN AN IFRAME OR SIMILAR AND MUST BE SIZED BY PERCENTAGE 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
mysql 5.1, php, linux