There is a database with statistics tables, 4 identical tables with different names and hierarchy - // category - subcategory - project - table with data //, how to select data by dynamic form select to display data from a specific table by category, subcategory and project?

  • In short - take the value of the category of the subcategory and the project - substitute them into the function that will generate the request for you - and make the request) In the meantime, do not provide more details on what language you are doing, you can say no more. - Moonvvell

1 answer 1

If the tables are completely identical, then I recommend to merge all the data from them into one general table, add the TYPE indexed field to it and make selections on this field.

  • Tables with constantly updated information. - Andrei
  • @ Andrei So what? How does this prevent them from merging them? - Anton Shchyrov
  • Requests, four different projects, info displayed in highcharts, trying to write a request for output <select name = "category" id = "category" class = "form-control"> <option value = ""> Select Category </ option> - Andrei
  • @ Andrei Once again, I repeat slowly. Create a general table, merge all the data into it and delete your identical tables. After that, all requests for selection and modification of data are made with a new table - Anton Shchyrov
  • Request code prompt base CREATE TABLE IF NOT EXISTS Table ( i int (11) NOT NULL AUTO_INCREMENT, day char (3) DEFAULT NULL, dt char (8) 64) DEFAULT NULL; proxy char (64); DEFAULT NULL; host char (64); DEFAULT NULL; lang char (2) DEFAULT NULL; utf8 ROW_FORMAT = DYNAMIC; - Andrei