MySQL Structure - Order Portal
Hi there, I'm creating a customer order portal. i've done some simple stuff with PHP and MySQL before but I'm afraid I'm stuck here.
The system will allow existing customers to login and order products. I have around 3000 customers and 1000 products.
I want to be able to set in MySQL in some sort of way what customers can/can't order.
So I have two tables at the moment, one with customers & information and another with products.
My problem is one customer maybe able to order 500 products and another one maybe able to order a different 200 products.
Whats the best way of structuring this in MySQL?
Subject
Written By
Posted
MySQL Structure - Order Portal
July 14, 2016 10:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.