Problems related to data query in phpmysql-it is not easy to add Where. I do not know what is wrong.

Phpmysql data query problem-it is not easy to use with Where. I do not know if there is an error $ query_CN = & quot; SELECTPestcide_trade_namefrominsecticidewhereCompany_name = Bayer & quot ;; $ q_result_CN = mysql_que php mysql data query problem-add Where is not easy to use, I do not know what is wrong
$ Query_CN = "SELECT Pestcide_trade_name from insecticide where Company_name = Bayer"; $ q_result_CN = mysql_query ($ query_CN );
While ($ each_ques_CN = mysql_fetch_row ($ q_result_CN ))
{
Print $ each_ques_CN [0];
}

If I do not add a where clause, $ query_CN = "SELECT Pestcide_trade_name from insecticide. If it is added, the following Warning will be reported

Warning: mysql_fetch_row (): supplied argument is not a valid MySQL result resource in d: \ apm_setup \ htdocs \ search. php on line 33

Line 33 is the line while ($ each_ques_CN = mysql_fetch_row ($ q_result_CN). What is this. Thank you.

------ Solution --------------------
$ Query_CN = "SELECT Pestcide_trade_name from insecticide where Company_name = 'bayer '";
------ Solution --------------------
Discussion

$ Query_CN = "SELECT Pestcide_trade_name from insecticide where Company_name = 'bayer '";

------ Solution --------------------
... Where Company_name = '$ name '";