Unknown Column in Field List

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
unorthodokz
Forum Newbie
Posts: 11
Joined: Tue Apr 10, 2007 2:33 pm
Location: Nashville, TN

Unknown Column in Field List

Post by unorthodokz »

Hey ya'll,

Using PHPmyAdmin I just added all of my tables to my database, but now I'm getting this error:

"Unknown column 'sc_order_email' in 'field list'" which can be seen on the webpage I'm workin on here: http://www.musicdocumentaries.org

I'm a noob to PHP/Mysql, seeing as this is my first webpage using the two of them. I've search for answers in google and the search function here but couldn't find anything that clearly addressed this issue.

Any information/solutions to the problem are GREATLY appreciated.

-C
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

A table has one or more (named) fields. You query uses a field that does not exist in the table.
Post Reply