Dynamic Dropdown - Dynamic Array

I'm following the tutorial for using Dynamic Dropdowns and the Primary dropdown is showing up empty. Attached is a sample .php page and .sql of the data.

Basically I want to Display the column Division in the first dropdown and then auto-populate the second dropdown with column AreaName where Division is equal to what was selected in the Division dropdown.

Seems pretty straightforward but I guess I'm missing something.

First, before the first select list, add the the following code to set the recordset to the first record:

<?php
$rows = mysql_num_rows($Recordset1);
  if($rows > 0) {
      mysql_data_seek($Recordset1, 0);
	  $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  }
?>

then select the first list, and add the Populate List from Array behaivor.

open the behaviors window:
Window -> Behaviors

NOTE: Behaviors, not Server Behaviors

click the plus button and go to WebAssist -> Dynamic Dropdowns -> Populate List from Array

Please view updated private .php

it is working for me when I test your file.

when i select R from the parent list, it populates the child list with Collier, whhen I select V, it popualtes the child list with Charlotte

Oh geez, must have been cached...works great! Thanks for the help as always Jason, really appreciate it.

you're welcome.