An old man of around 68 years of age shared a story with me; he said that he used to be sick for months and that there was no cure; he even spent two or three months in the hospital and fell sick three or four times within a year. However, one day, he went to an islamic scholar praching some days of Muharram. He said that the scholar told him that on the ninth day of Muharam, Allah would command all the water in the world to turn to Zamzam and that in that night of that, one should bath before going to sleep, and in morning too, and that one would not become sick again until the following year. The man said that he has been doing this since 1986 and has not become sick again and that although he use to have a little headache as soon as he used a drug once, it would relieve him. I looked for a hadith but could not see anything like that. I went back to him to ask from which scholar he got this. He said that he heard it from the mouth of his scholar, Shaykh Kamaludeen Al-Adabby in the Ilorin Kwara State of Nigeria. He even swore to me that it works and that I should try it. Please, is this allowed in the Sunnah?
All perfect praise be to Allaah, The Lord of the Worlds. I testify that there is none worthy of worship except Allaah and that Muhammad is His slave and Messenger.
We do not know of any basis for this in the Sunnah. The knowledge of such matters, if proven correct and authentic, cannot be acquired except through divine revelation. There is no doubt that such claims are falsely attributed to the Prophet ; they are clearly fabricated. The Prophet said, "Telling lies about me is not like telling lies about anyone else. Whoever tells lies about me, let him take his place in Hellfire."[Al-Bukhari and Muslim]
Allaah knows best.
You can search for fatwa through many choices