Jump to content

php/mysql error: Unknown column 'col' in 'field list'

Recommended Posts

Unknown column 'col' in 'field list'


Is the error message, i tried all kinds of backticks, and quotes but doesnt work


So I was thinking, how can I check (in phpmyadmin or in the mysql console) whether a table has the columns that are needed?

Link to post
Share on other sites

What does your query look like? I would assume you're supposed to know the structure of the database tables you're querying.

Link to post
Share on other sites

With column heading it is as if you are adding new field name, you can do this using ALTER seehttp://www.w3schools.com/sql/sql_alter.aspThe row is individual records that hold details relating to the column heading.You can only add heading once only with alter unless you use unique column heading each time, which would not be a practical way of creating table.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...