I tried building this query with Laravel
$products = DB::table('products as p')
->join('manufacturers', 'manufacturers.id', '=', 'p.productManufacturerID')
->join(DB::raw('SELECT *
FROM `product_options`
GROUP BY productID'),function($join){
$join->on('product_options.productID', '=', 'p.id');
})
->select('p.productSKU', 'p.productName','p.productPrice',
'p.productSize','p.productDescription','p.productQuantity',
'manufacturers.brandName')
->where('p.productCategoryID', $category->id)
->get()->toArray();
and getting error http://ift.tt/2ibBAXq what is the issue there
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire