No, they don't work, and most times they smell horid. Get an actual cologne, one that's not cheap and smells fairly good. Those will attract women more. General hygiene as well will give you a light, clean scent, which is sometimes even better.
Honestly, though, I do not think that a man's smell, no matter what, would attract women like they do in the commercials. Those are supposed to be funny and amusing, not realistic - women do not flock to a man simply because he's wearing a nice cologne. I mean, perhaps some do...but not most.