Trojan War (1997), a teen comedy directed by George Huang, is recognized as a significant box-office failure that earned only $309 during its theatrical run. The film follows Brad Kimble (Will Friedle) on a chaotic, night-long quest for a condom to pursue a romantic interest, only to realize his connection with friend Leah Jones (Jennifer Love Hewitt). Despite its initial failure, it has gained cult status as a 90s nostalgia piece. Read more about the film's production and plot on Wikipedia .