Simple Query

[ameliabob]

I have been looking at this for a couple of days and cannot figure out what I am doing wrong. Hopefully another set of eyes will help. I am trying to send this query: SELECT symbol,stockName, buysell FROM followlist WHERE symbol = 'DHI' as $result = mysql_query("SELECT symbol,stockName, buysell FROM followlist WHERE symbol = 'DHI' ") or die(mysql_error()); and get this message back. SELECT symbol,stockName, buysell FROM followlist WHERE symbol = 'DHI' didn't take: Unknown column 'dhi' in 'where clause' I know that dhi is not a column but "symbol" is a column. What am I not seeing

[davidb52]

rename it to dbsymbol it may work.Sometimes sql thinks you meaning a tag instead of a (what you want)Like this:SELECT select,where,group FROM where WHERE group=order by Sql can't handle this 2x select , 2x where you see the problem?

[sonu]

I think you had not created "DHI" column or there is some spelling mistake try to change it with different name.Hope it will work. Thanks!

[justsomeguy]

Those single quotes may be some other character, try retyping the query with regular single quotes.

[Mudsaf]

I tryed query this worked.

SELECT symbol,stockname,buysell FROM followlist WHERE symbol = 'DHI';

It checked 'DHI' from symbol column, works for me all i require is table where is these columns (symbol, stockname & buysell)