We have created a simple "template system" of which data is stored in a mysql database. The DB consists of only 2 tables:
-one with the different pages
-one with entries for products lists
Different pages table:
----
consists of:
title field
template field (where you can select the template to be used)
6 text fields (which aren't all used in each template)
6 image fields
6 options image_enlarge (to check if this specific image is enlargeable or not)
The lists field:
Is used for pages with a list of products, each entry in the table is another product, a cell called page_id links each product to it's referring page!
The lists field will only be called if a specific template is used.
What we need in the script is:
o A secure login system for our customer
o An automatically generated list of different pages in the database
o An edit option to change each page, it would be nice if depending on the template used, the corrensponding number of text fields and image uploads are shown. This is not really nescesary but I think easy to implement for a professional programmer

o An upload option for each image (as mentioned), it would be nice if it's possible to resize it automatically with GD. If the picture should be enlarged, it would be even nicer if it could be automatically resized to 2 different sizes. An option to enable/disable enlarge per picture should be available
o For the products pages, there should be an option to add, edit and remove products to the list, including adding and removing pictures.