The Mazda Capella was commonly known in markets outside Japan as the Mazda 626. The Mazda 626's sixth-generation was built on the GF platform and released in 1997 for the 1998 model year.
Sounds like your battery had power, but the heavy draw of the starter motor uses up the depleted capacity. Can you jump-start it? Try another battery? Charge your battery with a pulse charger? That'd be the easiest to check first; more later, once that's ruled out.