Country, state, city database

[ioop]

I need to design an event database by country, state, city for clients. How is the best way to begin this project for speed of initial selection of location.

[dalecosp]

Hrm. Maybe a tables of countries, a table of states, and a table of cities? 😉

Well, you asked.....

When you say "speed of initial selection of location", you probably should give more info. There are several ways to handle data, as you might imagine, and PHP is only one of them (although it's the one we're concerned with here). I've seen some pretty "quick" interfaces recently that used Javascript to read an XML file without a page refresh. If you're comfortable in Javascript, etc., that might be a go.

[richie]

1. Create normalized tables.

2. Create good indexes according to your queries.

3. Use EXPLAIN to assess the performance of your queries.

4. And as dalecosp suggested, look at AJAX.