Jump to content

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


WesleyA

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 comment
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 comment
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 comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...