A DB Design Question

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

A DB Design Question

2002-06-06 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