在where子句中的PHP错误未知列

Question

A Database Error Occurred

Error Number: 1054

Unknown column 'footer' in 'where clause'

SELECT `submenus`.`text_ge` as sub_title, `staties`.`title_ge` as stat_title, `staties`.`id` as stat_id FROM (`submenus`) JOIN `staties` ON `staties`.`submenu_id` = `submenus`.`id` WHERE `footer` = 1 GROUP BY `staties`.`id`

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

Line Number: 330

I have some problems here, I don't know what to do.

Answer 1

Does footer exist?

If it does, then specify:

<table_name>.footer = 1 

in the where clause.