Hello,

I am having problem querying my database. If anyone can help it would be very appreciated.

I have the controller below which query the database from a form in the view and it works fine. Each of the results(phone model) has relationship with the Product as Phone -> has many -> Products

What i want to implemented is add a query to select ONLY the ones that has Products under them.

I tried several things like adding has('Product') in front of the first where without luck so want i think now is adding one more column as ProductCounter under Phones

Any help here?

Thanks in advance

<?php

class PhoneController extends BaseController{

	public function getShow()
	{	
		//$phones = Phone::paginate(24);

		$phones = Phone::where(function($query){
		$min_weight = Input::has('min_weight') ? Input::get('min_weight') : null;
		$max_weight = Input::has('max_weight') ? Input::get('max_weight') : $max_weight = null;
		$brands = Input::has('brands') ? Input::get('brands') : null;
		if($min_weight==NULL){
			$min_weight=0;
		}
		if($max_weight==NULL){
			$max_weight=9999999999;
		}
		if(isset($brands)){
			foreach ($brands as $brand) {
				if(isset($min_weight) && isset($max_weight)){
					$query-> orWhere('weight','>=',$min_weight);
					$query-> where('weight','<=', $max_weight);
				}
				$query->where('manufacturer','LIKE', $brand);
			}
		}

		if(isset($min_weight) && isset($max_weight) ){
			$query-> where('weight','>=',$min_weight);
			$query-> where('weight','<=',$max_weight);
		}
	})->paginate(10);
	return View::make('phones.all', compact(['specs']))->with('phones',$phones);
	}