A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/products.php

Line Number: 212

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/products.php

Line Number: 213

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/products.php

Line Number: 214

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/products.php

Line Number: 216

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/products.php

Line Number: 217

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/products.php

Line Number: 221

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/wwwadams/public_html/system/libraries/Exceptions.php:166)

Filename: codeigniter/Common.php

Line Number: 356

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 ') AND ord.products_id != ORDER BY RAND() LIMIT 5' at line 6

SELECT DISTINCT ord.products_id, products.product_code, products.price, products.product_db_name, products_colors_images.products_colors_id, products_colors_images.image_name FROM (order_details as ord) JOIN products ON products.id = ord.products_id JOIN products_colors ON products_colors.products_id = products.id JOIN products_colors_images ON products_colors_images.products_colors_id = products_colors.products_colors_id WHERE `ord`.`orders_id` IN ( select order_details.orders_id from order_details where order_details.products_id = ) AND ord.products_id != ORDER BY RAND() LIMIT 5