Help on query to find the count

[dinu123]

Hi,

I am new to mysql.I am having a database with field apl_name of type text.

In it i am having some data like
d:\dda\dmm.exe for 5 records.

I want to conut that records for name=\'david\' which name is an another field of the same table.
when i tried query like

SELECT count(*) as zz FROM dummy1 where name=\'david\' and appl_name=\'d:\dda\dmm.exe\'\";

it is giving 0.
But the fact is in the data base i am having 4 records.
Please help me in solving this.
thanks in advance
dinu

[Anon]

mysql_query("SELECT count(*) as zz FROM dummy1 where name=\"david\" and appl_name=\"d:\dda\dmm.exe\"");

try that........

[dinu123]

Thanks for your help.But i am having a another question .The data will come from other place.I am trying to read that field in php and i have to make count on that field.
I wonder why it is not able to get the count.if the data is having /.For the rest of the data it is comming.
please help me regarding.Thanks in advance.
sudheer