I need a perl database script for [login to view URL]
The project amounts to a Messageboard with Search Engine
There are three functions needed USER input, Search Engine and Admin
User requirements
Input form and database structure
Field 1: Select Category from dropdown list
Add "Please Specify" field if Category = "other"
Field 4 "date" (automatic)
Field 2 "City" (user input)
Field 3 "State" (dropdown list)
Field 5 "Offender" (will be name of person or company that gave bumd deal to you)
Field 6 "bdtitle" title of this BumDeal story
Field 7 "bdstory" (text area box for user story)
Field 8 "other user comments" (this is where other users with similar issues with this offender may chime in or give advice to the person posting the BumDeal)
Field 9 "Email" Mandatory
Field 10 "Name" Mandatory
Field 11 "Phone" Optional
form results should go to bumdeal [login to view URL]
** ALL Posts must be approved before being able to be posted
Search Engine search box to put on front page of [login to view URL]
Search fields = City, State, Offender, title,
Display results should include the ability for other users to add a comment to that bumdeal story (like a message board does)
Admin functions
Add or delete categories
Add or delete records