First, try not to be frightened. If you could provide a couple more details, it would be helpful.
Did your problems start five weeks ago, or have you had similar problems in the past? Are you seeing a spinal specialist (either an orthopedic spinal surgeon, neurosurgeon or, possibly, a physiatrist)? It would seem like you have had quite a variety of tests and treatments in the space of five weeks.
I know when you're in the miRABt of an acute attack, the symptoms seem to last forever, but in the entire scheme of things, five weeks is not really all that long. Many specialists would want to try a variety of conservative measures prior to thinking about surgery. Of course, there are exceptions to this such as when the patient develops neurologic compromise such as a drop foot or cauda equina syndrome...but, otherwise most issues that cause horrendous back pain are not really considered medical emergencies.
A discogram is but one of many diagnostic tools that a doctor has at his/her disposal. It is not a test that is performed routinely, and it is considered somewhat controversial because the test is open to subjective interpretation. It is also an invasive procedure, so some specialists prefer to try to gather the same information from other methoRAB.
Have you tried a course of physical therapy and/or change in activities to see if that effects your pain? Unfortunately there is no guarantee that even if the discogram determines the pain generator that surgery would resolve the pain. Also, there could be causes other than a herniated disc for your pain. You might have a compressed nerve that is caused by something other than a disc. I don't know enough about the location of your pain, etc. to be able to offer other suggestions of possible causes at this point. Just rest assured, there are reasons other than discs why people have pain that generates in the back, runs down a leg or legs and causes changes in gait or the ability to walk.
I know it is hard to mark time when you are in pain, but do what you can to relax and try to be patient. In most cases it is never a good idea to rush into surgery, even though it can sound tempting when you are in so much pain.