You need a prescription. If you actually need it, go ask your doctor. Codeine is for pain. Codeine cough syrup is used to treat sore throat conditions like strep throat. Promethazine, aka Phenergan, is for nausea.
I hope this helps.
I am a paramedic and have worked in emergency medicine for several years.