I'm getting "Error 1109 : Unknown table 'questions' in where clause" when I do the simplest query.
This is the query: SELECT * FROM questions; My database has the following two tables: CREATE TABLE subscribers( subscriber_id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, email varchar(50), gender varchar(10), username varchar(50), password varchar(50), birthday char(10), zipcode char(15), register_date char(10), FULLTEXT (username) )type=MyISAM; CREATE TABLE questions( question_id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, question_text varchar(500), question_date char(10), subscriber_id INT UNSIGNED, answer_count INT UNSIGNED, email_when_answered int(1), question_verification_key varchar(10), question_comment_vote varchar(10), FULLTEXT (question_text) )type=MyISAM; In my questions table, the question_comment_vote row can be set to '1' or '2'. I don't get Error 1109 when question_comment_vote is set to '1' but I do when it's set to '2'. How strange! It would be so great to get some insight into this. Thanks