3 tablolarla karmaşık mysql sorgu

0 Cevap php

şimdi ben ok üç tablo var?

  1. catgories | cat_id
  2. alanlar | area_id
  3. reklamlar | cat_id - area_id

now i want get the the areas under the catgories with contain the ads this mean - catgorty -- area contant catgorty ads example i have cars as a catgory and egypt as area and a car for sale as ads now i want show the areas under the catgories which contain ads this mean i have egypt usa canda and one ads in egypt now i want show it like cars -- egypt and if i have one more ad in the usa it appear cars --egypt --usa this mean give me the areas with contain ads under that catgory

0 Cevap