Database Error, Error Number: 1054 for Asc data by manufacture name

[novianbiz]

I got this error message when i try to Ascending by manufacture_name:

A Database Error Occurred

Error Number: 1054

Unknown column 'manufacture_name' in 'order clause'

SELECT * FROM (products) ORDER BY manufacture_name Asc

Filename: C:\xampp\htdocs\ci_admin_panel_new\system\database\DB_driver.php

Line Number: 330

[syscoid]

SELECT * FROM (products) ORDER BY manufacture_name Asc

changes with
SELECT * FROM (products) ORDER BY manufacture_id Asc