title: Deciding a coding strategy, is there a simpler way?
body: <p>I'm looking for help more on strategy than specific code. So please don't take this as a request to write large pieces of the code for me. I need to write it in PHP and it needs to do the following:</p>
  
  <p>First, I need the user to make a selection of locations from a list, the script will then display a stored distance between those two locations.</p>
  
  <p>For this my initial idea is create a database, have a table for each place, and then have a row for each other place in said table. So for instance of they choose "LA" and "Seattle", it will grab the "LA" table, then output the value for the "Seattle" cell. The only problem I can think for this, is that it has a lot of tables, and it would make it really difficult to add new places, because not only do you have to add a new table for that place, but also a new row in all the other tables.</p>
  
  <p>Is there a better way to approach this?</p>
  
  <p>I know there is some functionality that allows you to import excel spreadsheets, but I am not familiar with it, or how easy it would be to index that data for recalling specific cells. </p>
  
  <p>Appreciate the help!</p>