http://www.mazdas247.com/forum/showthread.php?t=93218&highlight=led+cupholder
I did something similar with the footwells, but with LEDs only.
The LED Light Parts list:
18 x 5LED Orange 15
PowerPuck #2008-350mA driver
Everything else (18ga. wire, heat-shrink, switch, project box) was from RatShack...
I haven't finalized the installation yet, but I have 2 taped under the dash and 2 to the bottom of the seat on the driver & passenger side, then 2 more taped to the underside of the seat rails for the rear seat footwells.
Power was tapped from the accent light in the ashtray, so they only come on with the parking/headlights.
...With 12 LEDs on this driver, they're only
slightly under-driven, and the light level is just about perfect. The color matches pretty well, too. I haven't decided if I'm going to put any lights in the cupholder, glove box, or console storage...
I'll try to get some pics tonight, now that I have a good camera.