RE: Help with database Design

2002-12-22 Thread Adolfo Bello
les, so each > > > ingredient must be added to the general total. I need help > > > with the design because I don't want to have database anomalies. > > > > > -Original Message- > > > From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]] > > > S

RE: Help with database Design

2002-12-22 Thread Jeff Snoxell
eneral total. I need help > with the design because I don't want to have database anomalies. > -Original Message- > From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 22, 2002 11:22 AM > To: [EMAIL PROTECTED] > Subject: Help with data

RE: Help with database Design

2002-12-22 Thread Adolfo Bello
> -Original Message- > From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 22, 2002 11:22 AM > To: [EMAIL PROTECTED] > Subject: Help with database Design > > create table recipes( rid int not null primary key, rname ) ; create tabl

Re: Help with database Design

2002-12-22 Thread Peter Brawley
Ricardo, you're asking how to normalise your database. There are links to some good intro tutorials at http://www.artfulsoftware.com/dbresources.html PB - [filter fodder: sql, mysql] > Hi, > > I'm having problems trying to figure which is the best way to solve a design > : > > I'm designing

Re: Help with database Design

2002-12-22 Thread Peter Brawley
Ricardo, you're asking how to normalise your database. There are links to some good intro tutorials at http://www.artfulsoftware.com/dbresources.html PB - > Hi, > > I'm having problems trying to figure which is the best way to solve a design > : > > I'm designing a delivery program with php

Help with database Design

2002-12-22 Thread Ricardo Fitzgerald
Hi, I'm having problems trying to figure which is the best way to solve a design : I'm designing a delivery program with php and mysql, and I'm having troubles with some tables, my problem is with the recipes, the recipes are divided into two tables one with a recipe id and description the other

Need help with database design

2002-06-11 Thread Michael Ivanyo
I would like to set up a MySql database that will store distance information for a milage lookup program. The user will enter the origin city and the destination city for some predefined trips. Then the query will need to return the milage broken down by state. For example, for an origin city i