I need help with a small personal project
using MySQL, CGI, PHP or Perl, HTML....
I have 3 tables: Category, Question, Comments
DateTime field defaults to the current time
Primary key ID is auto generated sequentially.
I need the following forms
User interface
---------------
1. List of Categories
2. Clicking a category user sees list of
questions and comments for each question
(if any). Each question has link to add
comment to the question
3. Form to create new category
4. Form to create new question
Admin interface
----------------
It will go into some password protected directory
Basically the same (1 through 4 ) but with the following
features
List 1 but with links to delete and edit category
List 2 but with links to delete and edit category
I will need it to be deployed (I will provide hosting account
details) and a brief explanation how to re-deploy it and export
data into MS Access, delimited file, or whatever is easiest.
Make sure it is secure enough and SQL statements cannot
be executed via submited forms/URL, etc.
Thanks.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
## Platform
UNIX, Linux, MSIE, Netscape