php - Issue with multiple mysql joins

819

I have 5 tables.

This is my table sequence

1. tbl_item_cate_values
2. tbl_cata_cate_multilang
3. tbl_catalog_category
4. tbl_data_type
5. tbl_cata_cate_type_mulitlang

JOIN linking

  1. tbl_item_cate_values.item_id = tbl_cata_cate_multilang.category_id
  2. tbl_cata_cate_multilang.id = tbl_catalog_category.catalog_id
  3. tbl_catalog_category.data_type_id = tbl_data_type.id
  4. tbl_cata_cate_type_mulitlang.category_id = tbl_cata_cate_multilang.category_id

JOIN 3 tbl_data_type.data_type_name is 'dropdown' so JOIN tables tbl_cata_cate_type_mulitlang.category_id = tbl_cata_cate_multilang.category_id otherwise JOIN only first 3 tables how can I do this, thank you advance.

enter image description here

People are also looking for solutions to the problem: php - What algorithm can I use to solve this case(string matching/word matching)?

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.