Your chances of fainting will depend greatly on the severity of your phobia.
I have a phobia of needles myself, but only for having blood drawn/injections - they don't bother me with piercings.
If you're the same then I think you'll be fine. However, if you know piercings trigger your phobia too, then I'd say maybe give blood one day and go back the next day/weekend for a piercing.