I need to know the film where a man is shot in the foot and nearly kills himself by riding in front of the enemy on a horse so he doesn't lose his foot then he is posted on the front line alone and then waits for support to arrive

I believe you are talking about "Dances with Wolves" starring Kevin Costner.