I need to create what I imagine to be a simple website with basically 4 pages:
1. The first one is private (only people with admin rights can see it). This page is where I create a list with several products.
Thinking about it as a database, this page should generate the (unique) table containing *all* the products and their characteristics.
2. The second page is where the users register their information. It is open access to everyone. Here the users register and save their info.
DBwise, this page would feed the (unique) table containing *all* the information relating to each user.
3. The third page is where each user (previously registered) selects a product (from the list that I created) and gives the price that they are willing to pay (or sell), the location of the product, and any other information related to the sale.
DBwise, this should be a (large) table containing the userID, ProductID, and all the conditions related to the sale (price, quantity, buy/sell, location, etc., date of the post)
4. The fourth page would be only based on queries of the table in 3. For instance, it would contain (apart from several ads), graphs with the buy/sell prices each day (like a graph of a stock index for instance).