dimanche 22 juillet 2018

How to fetch the Makes name of the given Brand of Type=Car? [Laravel]

I have following tables in Laravel.

brands

id name 1 honda 2 suzuki

types

id name 1 cars 2 bikes

makes

id name type_id 1 honda amaze 1 2 honda shine 2 3 suzuki baleno 1 4 suzuki racing 2

brand_make

id brand_id make_id 1 1 1 2 1 2 3 2 3 4 2 4

brand_type

id brand_id type_id 1 1 1 2 1 2 3 2 1 4 2 2

From the above tables, now how can I fetch all the Makes of Brand which has Type id = 1? E.g. Give me all Make of Honda cars



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire