firstly, there is no need for usernames/passwords in the database as i will use .htaccess for this. the following is the best i can explain the detail that is required for the product management page that is required.
the products page itself should start with a dropdown list of all product types and have a submit button. the result would show a list of varieties of that product with the same layout as there is currently. details of the current site layout will be given later.
the admin page should have options for "add a product" & "edit a product".
data fields on the "add" page should be "product name", "description", "proscons", "nutritional" & "upload photo".
the "edit" page should first show a complete list of products in basic table format showing only the product name with an "edit" link and a "delete" link beside it. the user can then select the edit link and proceed to a page similar to the "add" page, only with all data prefilled.
when deleting a product, the associated photo should also be deleted.