The Carolina Inn is super close (aka a two minute walk...its on the same street on campus) to the Pharmacy School. It isn't that cheap though.
Another close and nice hotel is The Courtyard by Mariott...its about a 4-5 minute drive, straight up one road to the school. Even cheaper there is a best western on the same street (highway 54) that is also really close.
Good luck!