Antabuse is the drug you are talking about, it makes you really sick if you drink. It lasts longer than 24 hours though. It is also very dangerous - you can die if you drink on it - so a lot of Drs in the US will not even prescribe it anymore. I am no Dr. so please consult yours.
Campral is prescribed for cravings and does not have the danger Antabuse has. Talk to your Dr about this.