SQLSTATE [42S22]：找不到列：1054 [关闭]

Question

I'm french, sorry for my bad vocabulary. I have a little problem in my code, when I execute my SQL query I have this error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ID' in 'where clause'

Here's the code:

UPDATE s_data_bans SET `name` = '$name', `text` = '$corps', `idCat` = '$cat', `on` = '$unpub' WHERE ID='$id'

Answer 1

The error is showing that you have not a such column named ID in your s_data_bans table, check this out and make sure that the letter case of your column table matches your query (if it's lower case (i.e id) put WHERE id= ... in your query).

Good luck