Untitled

     $link = mysql_connect('localhost', 'vanilla', 'uc0bnj1o3');
      if (!$link) {
        print '<p style="color:red;">Could not connect</p>';
      }
      $res = mysql_db_query('hudicecream', $query, $link);
      if (!$res) {
        print '<p style="color:red;">We had a small problem. Could you please <a href="/find/" title="Try typing in your information again">try again</a>?</p>';
      }
      print "<h3>Here are the {$vars['max']} stores nearest to you:</h3>";
      print '<p align="right"><a href="#locator" title="Jump to the Locator">Search Again</a></p>';
      print '<table border="0" width="100%" summery="A list of locations that are selling Hudsonville Ice Cream in your selected area">';
      print '<tr style="color:#fff;background-color:#630;">';
      print '<th>Name</th><th>Address</th><th>Phone</th><th>Distance</th></tr>';
      while ($row = mysql_fetch_assoc($res)) {
        if ($color == "#fff") $color = "#ccc";
        else $color = "#fff";
        print '<tr style="background-color: $color">';
        print "<td>{$row['name_description']}</td>";
        print "<td>{$row['store_address']}<br>";
        print "{$row['city_name']}, {$row['city_state']} {$row['store_zip']}</td>";
        print "<td>{$row['store_phone']}</td>";
        print "<td>{$row['distance']} miles</td>";
        print "</tr>";
      }
      print '</table>';
    }
    print "<hr />";
  }