I am looking for guidance in handling database(MySql) one-to-many relationships using PHP and HTML.
How do I present master table(e.g. Orders) data(e.g. PO Number, Order date, Tax etc.) with detail table(e.g. Line Items) data (e.g. Product code, price, line number) where there can be one Order and many Line Items?
I'd like to present master table data at the top of a page and in the body of the same page a list of Line Item data....then allow the user to enter/update or delete master table data or insert/update/delete detail table data. We can assume a link between the two tables on an integer size 11 field called OrderNo.
This seems more straightforward in traditional client server tools like VB, but I don't have the proficiency yet with PHP and MySql and HTML. Any direction or help appreciated...
