jwk811 Posted January 5, 2007 Share Posted January 5, 2007 I tried to select something from my database like this "SELECT this FROM this WHERE this = $this" and it said that '$this' was an unknown column.. i knew it didnt exsist in the db but i was going to check if it did exist after that.. since this error comes up i cant get to it.. why is it doing this?[tt]Unknown column 'this' in 'where clause'[/tt] Quote Link to comment https://forums.phpfreaks.com/topic/32928-solved-db-rows-select-query-with-unknown-column/ Share on other sites More sharing options...
c4onastick Posted January 5, 2007 Share Posted January 5, 2007 Actually, its reffering to:'SELECT col FROM table WHERE [color=red]col[/color] = $this'I'd doesn't know what the column to check for the WHERE part. Make sure its not spelled wrong, happens to me from time to time. Quote Link to comment https://forums.phpfreaks.com/topic/32928-solved-db-rows-select-query-with-unknown-column/#findComment-153321 Share on other sites More sharing options...
jwk811 Posted January 5, 2007 Author Share Posted January 5, 2007 no it says unknown column and the part i was looking for? i double checked and its the right spelling n all.. Quote Link to comment https://forums.phpfreaks.com/topic/32928-solved-db-rows-select-query-with-unknown-column/#findComment-153323 Share on other sites More sharing options...
jwk811 Posted January 5, 2007 Author Share Posted January 5, 2007 cuz i didnt have the data in quotes.. ;D Quote Link to comment https://forums.phpfreaks.com/topic/32928-solved-db-rows-select-query-with-unknown-column/#findComment-153328 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.