thanks for writing to HCM,
with a herniated disc
there are some life style changes that you definitely need to undertake but complete withdrawal from sports activity may not be required.
before engaging yourself into sports it is extremely important for you to prepare your body for those stresses and strains that you may have when you will play. and this preparation can be done by strengthening your core muscles and maintaining the length of some very important muscles. core strengthening is all about strengthening your abdominal muscles (your rectii as well as your oblique muscles) and back extensors (errector spinae, multifidus and all your scapular muscles as well). And simultaneously maintaining the muscle length of - hamstring
muscles, quadriceps, hip extensors using stretching exercises. and in achieving all these a physiotherapist can help you surely.
once you get all this done then gradually start sporting activity with appropriate warm up and cool down after the activity will definitely help you. and you can play again.
one very important point which i want to highlight is - kindly do take advice of your medical practitioner who treated you with your herniated discs, as he/she knows your condition exactly.
i hope this helps
wish you good health