Air is the enemy of wine. That half bottle of Mouton Cadet left over after dinner will do best if tightly capped and stored in a cool dark place. No need to refrigerate. Most good wine stores will sell fancy stoppers , some that will even pump the air out of the bottle after re-capping but if you drink wine daily, all you really need is a good clean cork.
A good quality wine will last about a week at temperatures under 60F and out of the light. But think about it, would you really want to leave that "good" bottle of wine alone for that long?
The short answer:
Wine is a delicate living thing.
Theoretically wine will store for quite some time if it's not opened. Wine is bottled air-tight, so as long as there's no exposure to oxygen it won't spoil.
Ways to prevent exposure to oxygen:
Keep the bottle on it's side so that the bottom of the cork inside the bottle remains wet.
For reds, keep in temperatures of 57 - 60 degrees to maintain quality.
For storing red wine, the optimal temperature is 50 to 55 degrees Fahrenheit - not room temperature. So you should store your red wine varieties in a wine cellar or wine refrigerator at that temperature. What is most important is the temperature that the red wine is stored at. Red Wine should be stored at 50-55ºF so it can be stored in a wine rack located in an area kept at this temperature or a wine cellar/cooler or wine refrigerator kept at this temperature.
They both can it will extend the life of the wine if they are open but red wine should be consumed at 68 degree whites at 45. If they are just being stored cool dark and dry is the rule
Any wine whether red or white should not be stored after being opened for more than three days, even in a refridgerator.If you use an inexpensive rubber stopper and pump and pump the air out daily, an opened bottle of wine can last for several days, especially if it is stored in a wine cooler.
A wine cellar
That depends largely on the wine and how it was stored. I suggest having a back-up wine ready in case it's not still good.
Most red wines will last for decades if properly stored on their sides in a cool dark location.
Red wine can be stored, adequately, just a bit below room temperature. However, its taste is best preserved if it is stored in a cool place (55 degrees). White wine should be stored at even cooler temperatures than red wine (45 degrees).
optimal temp: 59 deg. Fahrenheit. Warmer than a fridge, but slightly cool.
It can last for many years if properly stored in a cool, dark place.
Wine can be stored in a fridge.
Not all wine is red. There are also types of white wine and rose wine. But, red wine is red because of the reddish color of the grapes it is made out of.
Red Wine. :D