A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 1

Filename: controllers/Home.php

Line Number: 189

Backtrace:

File: /home/mymedy/public_html/web/controllers/Home.php
Line: 189
Function: _error_handler

File: /home/mymedy/public_html/index.php
Line: 297
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/mymedy/public_html/library/core/Exceptions.php:272)

Filename: core/Common.php

Line Number: 573

Backtrace:

File: /home/mymedy/public_html/web/models/Root_model.php
Line: 925
Function: query

File: /home/mymedy/public_html/web/controllers/Home.php
Line: 248
Function: get_all_brand

File: /home/mymedy/public_html/web/controllers/Home.php
Line: 212
Function: brand_list

File: /home/mymedy/public_html/index.php
Line: 297
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 'ORDER BY `bn_id` ASC' at line 1

SELECT DISTINCT (bn_id),bn_name FROM brand_name,products WHERE p_brand=bn_id and p_main_cat_id=5 and p_cat_id= ORDER BY `bn_id` ASC

Filename: models/Root_model.php

Line Number: 925