Level 32
by the way, you have to select it first(the companie name) what about
$products = Product::join('companies', 'companies.id', '=', 'products.company_id')
->orderBy('companies.name', 'asc')
->select('products.*, companies.name');
1 like
Sep 22, 2016
6
Level 2
Order by and left join
I've been using the following code to pull out a list of products and their related companies:
$products = Product::join('companies', 'companies.id', '=', 'products.company_id')
->orderBy('companies.name', 'asc')
->select('products.*');
Which works OK but some products don't have a related company so were being excluded by the inner join. I therefore changed it to a leftJoin which does pull out all the products however this then seems to ignore the orderBy.
It seems to be ordering by the products rather than the company name when I use the leftJoin this way. Can't really understand why it would ignore the orderBy?
Level 2
Thanks,
Tried that but still won't order the results by company name. Even tried removing the select completely (hoping we then get all columns from both tables).
Wondering if I'm going to need to use some raw SQL!
Level 32
what about this
$products = Product::join('companies', 'companies.id', '=', 'products.company_id')
->orderBy(DB::raw("companies.name"),'asc')
->select('products.*, companies.name');
Level 2
Thanks again.
Weird one - repaired and optimised the MySQL database and it now works. Wonder if the table indexes were corrupt?
Level 32
hahaha thats coding!!
Level 2
Sure is! - those are hours of my life I'll never get back!
Appreciate your help anyway :-)
1 like
Please or to participate in this conversation.