ORDER BY `manufacture_name`

PRODUCT LIST OREDER BY manufacture_name ERROR:

A Database Error Occurred

Error Number: 1054

Unknown column 'manufacture_name' in 'order clause'

SELECT * FROM (`products`) ORDER BY `manufacture_name` Asc

Filename: /var/www/adminci.local/public_html/models/products_model.php

Line Number: 98