I wish to count the number of items

try this

select  name,count(name) as quantity,Product_Category, price, descriptions from Products where name = 'babydoll'
group by name,Product_Category, price, descriptions

but if you need the Product_Category, price, descriptions columns with them then you will get more then one row of result as all the values in these column are not same
if you want by name you can use this

select  name,count(name) as quantity from Products where name = 'babydoll'
group by name

You should quote the string in the where clause:

select  count(name) as quantity, name, Product_Category, price, descriptions from Products where name = 'babydoll'

Please not you are going to get just one record, because you are using count, that is an aggregate operator.

Actually i am trying to build an online product catalog. I need to call from the database columns, include (name,Product_Category, price, descriptions), and display them on the products page. Basically all items with same column name "name" definitely have the same values in other columns(...well, its the same item in a certain quantity). So i need to display the quantity available in the database also.
Any idea how i can put this with one single query?

Then repeat for all other items. Each time column "name" is different, call the various values.

In response to the subsequent comments...

You could try something like this

SELECT P.name, Product_Category, price, description, theCount
FROM Products P
LEFT OUTER JOIN (Select name, COUNT(name) as theCount from Products group by name)
          C ON P.name=C.name

I haven't had a chance to test this, so apologies if there are syntax errors. There is probably a more efficient way to do it as well

[Edit] Thought about this a bit more ...
IF (in capitals deliberately) name, Product_Category, price and description were static then it would make more sense to use

SELECT name, Product_Category, max(price), description, count(*) from Products GROUP BY name, Product_Category, description

Note that this would only make sense if there had only ever been one price (or if you only wanted the maximum price). The key point (from both solutions) is that if you want to extract other columns you either have to include them in the GROUP BY or do the grouping in a sub-query and return the total/count/max/average that way

I wish to thank everyone for your solution. None of the the solutions failed. Just that Mr CHill60 responded to some very specific criteria that i need. i have 3 weeks experience in ASP.net programming and wish to connect with good programmers out there like you, you and you.
im on skype: "ASPcode_gaffe". One more time, Thanks to y'all!!!