1)There's a bollywood movie called Qyamat Se Qyamat Tak
2)Qayamat is not a funny word. It some languages, it means "hell", in some others "judgement". According to Islam, qyamat is an equivalent the biblical "Apocalypse".
3)This one stars in the aforementioned movie that you used the song from:

Juhi Chawla