How to implement cell dependency on two variables in mysql?

Question

PHP

There is a certain database that can be edited and the type of output on the site is similar to an exel table. But it is not clear how to make the dependence and storage of data in the database so that the price (id_price) depends on what date it is (top) and on what type it belongs to (left)

Answer 1

We need to make one more table, a table of links with fields: id_type, id_date, id_price. According to this table, using JOINs, you can make a final table.
Another option is to add link fields to existing tables, but I would use the first option