On 2/6/08, mac jordan <mac.jordan at gmail.com> wrote: > On Feb 6, 2008 2:01 PM, Fred D Yocum <fdy at mcc.org> wrote: > > > I am planning a recipe MSQL database (for a Web site) and would like to be > > able to search/extrapolate via single ingredients (list of all recipes > > with carrots). > > > > > Been there, done that - see www.nibblous.com. > > I went with a full text search run every night (using Perlfect), coupled > with a tag cloud. >From a usability perspective, this may be a better idea. Otherwise, you're going to force the user to search for each ingredient they want in the recipe they are creating (because you need the ingredient ID to insert the recipe). If nothing else, at least use the autocomplete pattern! http://developer.yahoo.com/ypatterns/pattern.php?pattern=autocomplete -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.