How can AJAX work for me???

[kemper]

I am hosting a youth sport site and I want to display schedules by select teams.  Someone told me to try AJAX. 

 

I thought that I would want a drop down menu to select one of our 41 divisions, then a secondary search by team of that previously selected division menu.

 

My schedule is in a table with the fields:

* division

* date

* time

* home_team

* h_score

* visiting_team

* v_score

* field

 

I see problems, since secondary drop down menu would have to search two different fields to determine:

$sql = "
     SELECT *
     FROM schedule_table
     WHERE division = '{$_POST['division']}'
        AND ( home_team = '{$_POST['team']}' OR visiting_team = '{$_POST['team']}' )";

 

How do you suggest I populate the team selection?

 

I have 41 divisions with over 300 team to select from.  It cannot be by team name alone, since there are quite a few teams from several clubs and they use the same name.  I would like to give my visitors easier time locating their schedules.

 

Is AJAX the best option for visitors to create the WHERE variables?  If so, where do I start?

 

Thanks!

 

Kemper