[SOLVED] Unknown column 'month' in 'where clause'

[Shea]

Hi! Sorry if this has already been posted, but I can't seem to find it.

 

The query is:

SELECT * FROM `posts` WHERE (month='10' AND year='2007')

 

I've run it through PHP MyAdmin and it works perfectly. When I run it though PHP, I've been getting the following error:

Unknown column 'month' in 'where clause'

 

I know the column is there. The query is just unable to find it for some reason. Any help would be much appreciated.

 

MySQL version: 5.0.16

[dooper3]

try removing the brackets

[fenway]

try removing the brackets

Um, no.

 

You're likely not connecting to the right host/DB.

[Shea]

fenway, that was it! Thank you! It was still hooked up to the old database.