adding additional description fields to products

[webgodjj]

This is going to be a tough one...
I'm creating a shopping cart for Magic the Gathering cards. I need to be able to display and search the following info:
Card Name,Set,Color,Type,Rarity,Casting Cost,Power,Toughness,description,Artist,Converted Mana Cost,price.

Now, I can see that I would make the Manufacuture being the card set. I also imagine the either the color or the type (both??) are categories. However, Rarity, Casting cost... etc... How add fields for that?

I am comfortable in php and mysql, just trying to figure out the best way to handle this.

on the product page, it would show all these stats. On the search page, I could search for any Blue cards, that are Wizards with a Casting Cost of 1

[kobra]

Card Name,Set,Color,Type,Rarity,Casting Cost,Power,Toughness,description,Artist,Converted Mana Cost,price.

If you add all of this uniquely to your product description it will be searchable

[TheOracle]

You can also download my new contribution called: Additional products fields from my signature. Although, searchable fields are not yet available but has already been planned to be integrated in the future.