This will be an evolving project will develop into a larger plugin.
At present this is the first part of the project to develop a php script that will take data from a form created with the cform plugin... using the "Send form data to an alternative page" option. Process the data as follow.
The form in cforms will have the following fields - Name, Email Address, postcode and hidden fields of county,supplier types, success-url.
The script will take these details a create an email to the email address with details of suppliers of a particular type from the specified county. It also redirects to the success-url or displays an error.
There is no requirement for database entry. The database will be created with mysqladmin initially.
The databases will be as follows
County - id (unique int), countyname (text)
SupplierType - id (unique int), SupplierType(text)
Suppliers - id (unique int), County (linked to county id), SupplierType (int linked to SupplierType, CompanyName (text), ContactName(text), Telephone(text), Address1 (text), Address 2 (text), Address 3 (text), area(text),postcode(text), email(text), website(text).