Is prayer mandatory on a dying person who goes through a state of unconsciousness, then wakes up?
If he wakes up and was conscious, then he should pray the way/manner he could, but if he wasn't, then he is exempted from obligatory prayer as Allah Says in this regard (What means): "On no soul doth God Place a burden greater than it can bear." [Al-Baqarah/286].
Although engaged to be married, a man committed adultery with another woman. What is the ruling of Sharia on this?
All perfect praise be to Allah the Lord of the Worlds. May His peace and blessings be upon our Prophet Mohammad and upon all his family and companions.
There is no sin on the woman to whom this man is engaged; however, he is considered a cheater and must receive the punishment prescribed in Sharia. And Allah The Almighty Knows Best.
Is it obligatory for a wife who has been abandoned for many years to observe the waiting period (iddah) after her husband passes away?
If her husband passes away, the wife is required to observe the waiting period (Iddah), even if he had abandoned her, because she is his wife and inherits from him, so she must observe the iddah after his death. And Allah Knows Best.
I can`t afford to get married, what should I do to curb my sexual drives?
You should offer a lot of voluntary fasting, keep busy with useful and permissible acts and make supplication to Allah, The Exalted.