webcontents.org

Table Structure:
CREATE TABLE `drink` ( `id` int(5) NOT NULL auto_increment, `title` varchar(64) NOT NULL default '', `keywords` varchar(255) NOT NULL default '', `content` varchar(255) NOT NULL default '', `cat` varchar(64) NOT NULL default '', `subcat` varchar(64) NOT NULL default '', `ingredients` text NOT NULL, `method` text NOT NULL, `serve` varchar(64) NOT NULL default '', `nutriinfo` text NOT NULL, `visible` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9034 ;

Samples:
INSERT INTO `drink` VALUES (1, '57 Chevy recipe', '57 chevy, 57, chevy, vodka, southern comfort&reg; peach liqueur, grand marnier&reg; orange liqueur, pineapple juice, drink recipe, drink, recipe, alcoholic drink recipe, cocktail recipe, cocktail, mixed drink, martini', 'A delicious recipe for 57 Chevy, with vodka, Southern Comfort&reg; peach liqueur, Grand Marnier&reg; orange liqueur and pineapple juice. Also lists similar drink recipes.', 'Cocktails', 'Short drinks', '1/2 oz vodka<br>1 1/2 oz Southern Comfort® peach liqueur<br>1/2 oz Grand Marnier® orange liqueur<br> fill with pineapple juice<br></p><br>', 'Shake and serve.', 'Cocktail Glass', '(per 3 oz serving)</div><table cellspacing="1" cellpadding="0" border="0" width="395"><tr><td valign="top" width="135"><p >Calories (kcal)<br>Energy (kj)<br>Fats<br>Carbohydrates<br>Protein<br></p></td><td valign="top"><p >178<br>748<br>0 g<br>9.6 g<br>0.1 g<br></p></td><td valign="top" width="135"><p >Fiber<br>Sugars<br>Cholesterol<br>Sodium<br>Alcohol<br></p></td><td valign="top"><p >0 g<br>-<br>0 mg<br>-<br>26.2 g<br></p></td></tr></table>', 1);

INSERT INTO `drink` VALUES (2, 'A Little Dinghy recipe', 'a little dinghy, a, little, dinghy, captain morgan&reg; parrot bay coconut rum, malibu&reg; coconut rum, cranberry juice, pineapple juice, orange juice, drink recipe, drink, recipe, alcoholic drink recipe, cocktail recipe, cocktail, mixed drink, m', 'A delicious recipe for A Little Dinghy, with Captain Morgan&reg; Parrot Bay coconut rum, Malibu&reg; coconut rum, cranberry juice, pineapple juice and orange juice. Also lists similar drink recipes.', 'Cocktails', 'Long drinks', '2 shots Captain Morgan® Parrot Bay coconut rum<br>2 shots Malibu® coconut rum<br> cranberry juice<br> pineapple juice<br> orange juice<br></p><br>', 'Pour the shots into a glass of ice, and fill the glass with equal parts orange juice, cranberry juice, and pineapple juice. Garnish with a pineapple wedge, an orange slice, and an umbrella.', 'Highball Glass', '', 1);

INSERT INTO `drink` VALUES (3, 'Bad Habit recipe', 'bad habit, bad, habit, skyy&reg; vodka, peach schnapps, drink recipe, drink, recipe, alcoholic drink recipe, cocktail recipe, cocktail, mixed drink, martini', 'A delicious recipe for Bad Habit, with Skyy&reg; vodka and peach schnapps. Also lists similar drink recipes.', 'Shots & Shooters', 'by base-ingredient', '1/2 oz Skyy® vodka<br>1/2 oz peach schnapps<br></p><br>', 'Combine in a shot glass, vodka first.', 'Shot Glass', '(per 1 oz serving)</div><table cellspacing="1" cellpadding="0" border="0" width="395"><tr><td valign="top" width="135"><p >Calories (kcal)<br>Energy (kj)<br>Fats<br>Carbohydrates<br>Protein<br></p></td><td valign="top"><p >71<br>297<br>0 g<br>3.3 g<br>0 g<br></p></td><td valign="top" width="135"><p >Fiber<br>Sugars<br>Cholesterol<br>Sodium<br>Alcohol<br></p></td><td valign="top"><p >0 g<br>3.3 g<br>0 mg<br>0 mg<br>8.9 g<br></p></td></tr></table>', 1);

INSERT INTO `drink` VALUES (4, 'A Clockwork Tangerine recipe', 'a clockwork tangerine, a, clockwork, tangerine, sprite&reg; soda, kool-aid&reg; tangerine mix, bacardi&reg; gold rum, smirnoff&reg; vodka, drink recipe, drink, recipe, alcoholic drink recipe, cocktail recipe, cocktail, mixed drink, martini', 'A delicious recipe for A Clockwork Tangerine, with Sprite&reg; soda, Kool-Aid&reg; Tangerine mix, Bacardi&reg; gold rum and Smirnoff&reg; vodka. Also lists similar drink recipes.', 'Cocktails', 'Long drinks', '12 oz Sprite® soda<br>1 packet Kool-Aid® Tangerine mix<br>1 oz Bacardi® gold rum<br>1 oz Smirnoff® vodka<br></p><br>', 'Combine all ingredients in a beef pilsner. Stir together, and serve.', 'Beer Pilsner', '', 1);

INSERT INTO `drink` VALUES (5, 'Tiki Rum recipe', 'tiki rum, tiki, rum, kerns pineapple-coconut nectar, mango, strawberries, ice, malibu&reg; mango rum, drink recipe, drink, recipe, alcoholic drink recipe, cocktail recipe, cocktail, mixed drink, martini', 'A delicious recipe for Tiki Rum, with Kerns Pineapple-Coconut Nectar, mango, strawberries, ice and Malibu&reg; mango rum. Also lists similar drink recipes.', 'Other Drinks', 'Kerns Pineapple-Coconut Nectar', '1 can Kerns Pineapple-Coconut Nectar<br>1 medium mango<br>4 - 6 strawberries<br>1 cup ice<br>1 cup Malibu® mango rum<br></p><br>', 'Cut the mango into cubical pieces. Combine all ingredients, including the mango, in a blender. Blend well, and serve into pina colada glasses.', 'Pina Colada Glass', '', 1);