aSlolbongots28
New Member
I have 2 mysql queries retrieved from my php class 2 different methods and they look as it follows \[code\] SELECTdomains.id, domains.name, domains.meta_title,domains.meta_keywords, domains.meta_description,produkt_modul.keywords, produkt_modul.program_id,produkt_modul.title, produkt_modul.items, produkt_modul.search_type FROM domains JOIN produkt_modul ON domains.id = produkt_modul.domains_id WHERE domains.name='$domain_name' ORDER BY position\[/code\]is fetching the rows for my product modulesand the second one \[code\]SELECTdomains.id, text_module.position, text_module.title, text_module.textFROM domainsJOIN text_moduleON domains.id = text_module.domains_idWHERE domains.name='$domain_name' AND active= 1 ORDER BY position\[/code\]should give me the rows of the text modules.When I generate the html output of the rows in my view I would like to order theme after the positions value. what should look for example something like:\[code\]text_modul pos1prod_modul pos2prod_modul pos3text_modul pos4\[/code\]the actual view of the rows looks\[code\]text_modul1text_modul4prod_modul2prod_modul3\[/code\]How can I fetch the rows in such a way to have theme in the correct order.