What Happened to the Great 'Johnny Football'?

There once was a young Texas man who was poised to take the world of football by storm. He burst onto the college scene, ran roughshod over his opponents en route to a prestigious award, and then rushed off to become an NFL star. Unfortunately, things didn't work out so well, and he disappeared at age 23 into the nether world of the has-beens.