A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/Productdetail.php

Line Number: 16

Backtrace:

File: /home/revivewebsite/public_html/application/controllers/Productdetail.php
Line: 16
Function: _error_handler

File: /home/revivewebsite/public_html/index.php
Line: 309
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/Productdetail.php

Line Number: 18

Backtrace:

File: /home/revivewebsite/public_html/application/controllers/Productdetail.php
Line: 18
Function: _error_handler

File: /home/revivewebsite/public_html/index.php
Line: 309
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/revivewebsite/public_html/system/core/Exceptions.php:283)

Filename: core/Common.php

Line Number: 568

Backtrace:

File: /home/revivewebsite/public_html/application/models/User_model.php
Line: 270
Function: query

File: /home/revivewebsite/public_html/application/views/product_detail_view.php
Line: 4
Function: get_product

File: /home/revivewebsite/public_html/application/controllers/Productdetail.php
Line: 36
Function: view

File: /home/revivewebsite/public_html/index.php
Line: 309
Function: require_once

Database Error

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7

SELECT p.*,s.ingredient_name,w.material_name,c.category_name,co.color_name FROM products p LEFT JOIN category c on c.category_id in (p.category_id) LEFT JOIN ingredient s on s.ingredient_id=p.ingredient LEFT JOIN materials w on w.material_id=p.material LEFT JOIN color co on co.color_id=p.color WHERE p.product_id=

Filename: models/User_model.php

Line Number: 270