My transmission went out in my car. What's the smartest solution?

It's a 99 Honda Civic valued at about $4,500 with 105k miles on it. Should I rebuild the transmission, buy a used one, or just sell it? I'm pretty low on money but I want to have a dependable car.