In my mysql dababase i have 2 tables "brands" and "models"
CREATE table brands (
id int(11),
brand_name varchar(20));
CREATE TABLE models (
id int(11),
idBrand int(11),
model_name varchar(20));
I want to write a functions allowing me to display a result of requet like this :
Brand_name model_name
brand_1 model_1_1, model_1_2, model_l_3
brand_2 model_2_1, model_2_2, model_2_3