If you ask five people this question, you'll get six answers. There are conflicting opinions on this, and I'll try to outline the major options available in this answer. But first, a tl;drTL;DR
tl;drTL;DR
- Fate/stay night was originally a 2004 visual novel that had three routes - Fate, Unlimited Blade Works, and Heaven's Feel (in that order).
- The 2006 anime by DEEN mostly adapted the Fate route.
- The 2010 movie by DEEN adapted a highly condensed form of the the Unlimited Blade Works route.
- Fall 2014 and Spring 2015 saw another adaptation of Fate/stay night, this time by Ufotable, which adapts the Unlimited Blade Works route.
- At some point in the future, Ufotable will release a movie or series of movies that will adapt Heaven's Feel
- There is also a manga series that (I believe) adapts the Fate route, but I'm going to ignore it, because it's generally thought to not be that great.
I do not advise watching the DEEN F/sn anime (the TV series); it is poorly produced, both in terms of objective quality (art, animation, etc.) and in terms of faithful adaptation of the original work. If you really want to know what happens in the Fate route, I guess you could watch it, but honestly, lots of what happens in Fate is also referenced in UBW and Heaven's Feel, so you'll be able to piece it together after watching the Ufotable version of those two routes.