Re: MySQL Structure - Order Portal

[LLoyd Owen]

Here's the scenario I envision:

Customer logs into system, based on customer logged in they only see products that they're permitted to buy (In MySQL hopefully). They can then select the products and go through to purchase. But each customer will have a different array of products to choose from.

In the backend, there currently is a users table, products table and a customers table.

I need a way of defining what products (in the products table) customers (in the customers table) are allowed to buy. & In PHP I can use a query for current logged in customer to view XYZ products.

I can see the logic if there is just one product I'd need a column "ProductsAllowed" with the ID of the product, except there are a lot of products.

Sorry if it's confusing - i confuse myself with this.