1999 Mazda 626 LX review from North America

I bought my Mazda about a year ago and it had just over 20,000 miles on it. The check engine light came on about 2 days after I purchased the car. I repeatedly took it back to the dealer and was told it was just a glitch with the light, there was no engine problem. In the past year I have had the engine serviced every 3,000 miles and taken care of the vehicle. I just had an oil change about 3 weeks ago and everything checked out. My transmission just died today. I can't find a relatively inexpensive replacement, I am a college student working my way through school. I now have no way to school, no way to pay for repairs and I am disappointed with the dealership I have been dealing with. The "it isn't our problem" attitude has been given to me at 2 different Mazda Dealerships today. I am very disappointed in Mazda and the product they sell. My experience with Mazda is that it is not a reliable car and no one at Mazda is even attempting to show any customer care or satisfaction.