Expandable database construction script

Expandable database construction script required in php/mysql for multiple purposes My budget is $300 It sounds complicated ....but I dont think it is I've just been eact in spelling out requirements No design - just bare code which we can design around using css So keep the design very simple Admin builds the database Manager adds the products ================================================================== Admin chooses main categories Cat A Cat B Cat C Cat D etc etc etc can name these and add/edit/delete to these Admin chooses sub categories (child) for each main category (parent) Cat A:- Sub Cat A Sub Cat B Sub Cat C Sub Cat D Sub Cat E etc etc etc can name these and add/edit/delete to these Admin chooses how many "options" for each sub category and for each option decides how they should be displayed to manager when adding produucts a) drop down selection menu (all shown manager selects one) b) tick box (all shown manager ticks from list) c) radio (all shown manager selects one from list) c) text box (how long) can add/edit/delete these options. Further Admin options 1) if add picture display at what size: height: width: (in pixels) server resizes (yes no) In brief details display how many to a page? 10/20/30/50 ================================= So, for example admin can choose as main categories Carpets Vinyls Laminates admin can then select "Carpets" and build sub categories for that Style Colour Price Room Type Size admin can then choose sub cat "Colour" and choose how many options available for that Lets say he initially chose 8 he is then asked names for these colours and if he wants each colour displaying as drop down menu, tick box, radio, text box ================================== Once all Main Categories, sub categories and options complete >Build database ================================== Admin logs in and is presented with Main categories which he can click on to view sub categories and further click to dislay options within those sub categories He can add to / edit / delete any section ================================== Manager logs in and is presented with Main Categories Do you want to add a product? Cat A, Cat B, Cat C etc etc (Choose one) Do you want to edit/delete a product? Search or navigate to it Add product ============ New window - you are now adding a new product to <Main Cat name> Name of product: (text box) Choose a <sub cat a>: Choose a <sub cat b>: Choose a <sub cat c>: Choose a <sub cat d>: Choose a <sub cat e>: etc etc there may be 5 sub categories - there may be 25 sub categories (admins choice) if the option for sub cat a is a drop down menu - display it so manager can select one item if the option for sub cat b is radio box - display the options so he can select one option if the option for sub cat c is a tick box - display the options so he can tick those that apply if the option for sub cat d is a text box - display it so he can type in it etc etc Add picture? Browse to file (server will re-size this to <insert admin selected dimensions>) Add description: Text box (max 1000 words) Make featured? Yes: No: tick box (no is default) Those ticked yes will be displayed on index page Add review: Text box (no maximum) Save and add another product to <insert main cat name> or Save and return to Manager index Edit / Delete Product ====================== Manager can easily navigate or search for product to edit or delete. Viewer ========= left hand column displays Main categories (with amount of each product within that category) for example Carpets (146) Laminates (78) Vinyls (43) Main section displays any that are featured from all sub categories Display - thumbnail image | Name of product | Sub Cat A | Sub Cat B | More info More Info Displays all info with larger picture All should be SEO friendly ie [login to view URL] and not [login to view URL] Search box required <Choose Main Categories> - drop down menu which then populates with sub categories drop down menua Advanced search Show all sub categories (tick ones that apply) and search for text Results: shown as brief details and should be paginated 10 to a page The main aim of this project is that the script should be designed to create a database application for a wide multitude of applications. It could be useful for a carpet shop to dsplay their wares... it could be useful for a newsagent to display his wares.... It could be useful for a computer shop to show his wares.... Therefore it should be expandable and extremely editable A mini oscommerce application without the shopping cart Happy bidding