Chuen Sing Lee

Chen Dali was a waiter at an old Chinese restaurant. One night, she saw a ghost. It was the spirit of a girl who used to sing there. The girl was brutally murdered. The two fell in love with each other. Shortly afterwards, Dali's colleagues died one after another and to his amazement, they died exactly like what he had dreamed of. It seemed that the ghost was using Dali to find the murderer, and Dali found himself in deep waters...... (asianwiki.com)

A 1995 Hong Kong thriller.

A family guy cop (Melvin Wong) goes deep into a case and gets involved with a deranged killer. His partner and friend (Philip Chan) along with a new protégé Porky (Pat Ha) take over the case and look for his missing partner (who's "enjoying" the twisted company of the killer. Can Inspector Chan and Porky find Melvin before he becomes the latest victim of the psychotic killer?

Fa, is a psychotic loser, always between jobs, who never seems to have his prerogatives straight. His girlfriend at the time, Ah Hsia even starts to think he is psycho and decides to call off their relationship. Fa, being the psycho that he is, is unable to take the word "no" for an answer as he constantly hounds Ah Hsia and her family and practically stalks her. Worse comes to worst, as Ah Hsia cannot stand Fa any longer and practically disappears off the face of the earth and starts another li