If it hurts so bad I go to Urgent Care or ER. ASAP.
It's happened they try one pain killer and it doesn't work, then stick me with another one and EUREKA I feel way better. icodin is good for moderate pains.
Keep up with your muscle relaxers and anti-inflamatories, they will prevent the bad flare ups.