MySQL / PHP Programmer - Contract Position

[Greg Farries]

We are looking for a programmer to build a custom database solution that will allow us to display and sort thousands of public policy publications summaries. Each summary will be contain factual information about the publication.

The idea is to provide the visitor with as many ways as possible to drill down and find the information they are looking for. In the publications section of the wesite, we're going to be inserting thousands of policy publications covering 20 different categories (and then further broken down into 10-20 sub-categories for each category). We would like to give the user the ability to look (drill down) for a publication through three main avenues - By Topic, By Year and By Organization.

You can see what I mean below,

* By Topic
....o List all Topic Categories
........+ {category}
............# List all Topic Sub-Categories
................* {sub category}
....................o List all Available Years
........................+ (years)

* By Year
....o List all Available Years
........+ {years}
............# List all Topic Categories
................* {category}
....................o List all Topic Sub-Categories
........................+ {sub category}

* By Organization
....o List all Organizations
........+ {Organizations}
............# List all Major Topics Categories
................* {category}
....................o List all Topic Sub-Categories
........................+ {sub category}


We would need to be able to administer the database via a web interface. So submission forms, category additions, etc, would all need to be made via the web interface. We also need the data outputed in roughly the same fashion as you see here: http://www.policy.ca/policy-directory/International_Trade__Development_and_Finance/index.html

An example of a detailed page, the page that holds the publication summary, can be seen here: http://www.policy.ca/policy-directory/Detailed/119.html

Currently we are using a commerical software package, Gossamer Threads, but to enable the functionality above, it would require substantional modification of the core code and alot of manual insertion into the web interface.

If you're interested or need more information to provide a quote, please contact Greg, at, mailto:[e-mail].

Cheers,

Greg Farries