Mysql Unknown column in field list but column exists

hai darkc99

please check whether these two columns ddown_status , Machine ID are existed in your database table dorder or not

if not matched replace with exact column names

check it once and let me know the status

HI,
Check for Upper/Lower letters and
also Check that you are getting value in Where statement too.

ya machine id coloumn also exists and ddown_status too

you can see my another query with machine id works fine
q<<"SELECT * FROM dorder WHERE Machine ID = "<<"'"<

hai darkc99,

can you post the table structure and code once here?

so that we will try to help you out in this regard