Laravel multiple where queries not working

Question

I have the following query that seems to go wrong on the second where (search_price < rrp_price)

$query = Product::where('product_name', '!=', 'product_name');

$likes = DB::table('likes')->selectRaw('product_id, COUNT(*) as count')
                  ->groupBy('product_id')
                  ->orderBy('count', 'desc')
                  ->get();
foreach($likes as $like){
   if($like == $likes[0]){
      $query->where('aw_product_id', $like->product_id');
   }
   else{
      $query->orWhere('aw_product_id', $like->product_id');
   }
}
$query->whereRaw('search_price != rrp_price');
$products = $query->get();

So, if i take out the 'search_price < rrp_price' where i get all products filtered by those product ids with no price filtering, but when i leave the 'search_price < rrp_price' filter in, nothing seems to happen (search_price and rrp_price are always the same).

Am i doing anything obvoiously wrong with my where statements?

search_price < rrp_price is the last line. They are properties in the table. — Chris Merron
– Chris Merron, Commented Jun 23, 2017 at 6:51
Ah sorry, it should be != I've been playing around with != and < , but the issue remains on both so doesn't seem dependant on that — Chris Merron
– Chris Merron, Commented Jun 23, 2017 at 8:13

Bakar.A · Accepted Answer · 2017-06-23 06:46:38Z

1

Have you tried <> instead of != ? Maybe it'll work

answered Jun 23, 2017 at 6:46

Bakar.A

214 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bakar.A Over a year ago

It's the "not equal" operator for SQL.

Chris Merron Over a year ago

Ah thanks, doesn't make any difference. Thanks though!

Hardika Satasiya · Accepted Answer · 2017-06-23 07:03:54Z

0

There is error in your query Modified query is as below :

foreach($likes as $like){
   if($like == $likes[0]){
      $query->where('aw_product_id', $like->product_id);
   }
   else{
      $query->Where('aw_product_id', $like->product_id);
   }
}

edited Jun 23, 2017 at 7:03

answered Jun 23, 2017 at 6:54

Hardika Satasiya

3542 gold badges3 silver badges17 bronze badges

1 Comment

Chris Merron Over a year ago

That makes it a 'and where', rather than a 'or where', right? That part of the query works, it's the price filter that doesn't work.

aaron0207 · Accepted Answer · 2017-06-23 07:32:33Z

0

Did you try any other where syntax? something like this:

->where('table.search_price', '<>', DB::raw('table.rrp_price'))

Or maybe (Laravel 5+):

->whereColumn('table.search_price','<>','table.rrp_price')

answered Jun 23, 2017 at 7:32

aaron0207

2,3531 gold badge20 silver badges25 bronze badges

1 Comment

Chris Merron Over a year ago

They don't seem to work either. It's probably worth mentioning that i'm casting the value to a string (as some of the prices include a GBP suffix) and then stripping them of any currency values, and converting to a float. Also, if i run the query in the original question without the product id filter, the price filter works. Odd

Chris Merron · Accepted Answer · 2017-06-27 08:28:23Z

0

It turns out it was because the values were strings. Even though I was casting 'search_price' and 'rrp_price' to be floats, the actual laravel query seemed to be comparing string values in the database.

I modified the values in the database to be floats (for now) and now the query works.

answered Jun 27, 2017 at 8:28

Chris Merron

991 silver badge11 bronze badges

Collectives™ on Stack Overflow

Laravel multiple where queries not working

4 Answers 4

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related