What's the difference between a CD-ROM and DVD-ROM?

I wan't to buy an old PC game, but I don't know which to buy. It's a game from 1998 and I have Windows XP SP3.