help - dynamic selector with mysql

[Anon]

Can anyone help me to figure this out and I need to create dynamic selector (dropdown menu) from book(it will expand to 3 level) to chapter table?
please show me how I could do this and if you can post the sample script too?

Thank you.......

what I have on mysql as follows:

CREATE TABLE book (
ID int(11) DEFAULT \'0\' NOT NULL auto_increment,
Name varchar(255),
Graphic varchar(255),
Parent int(11),
Description blob,
DisplayPrecedence int(11),
PRIMARY KEY (ID)
);

CREATE TABLE chapter (
ID int(11) DEFAULT \'0\' NOT NULL auto_increment,
Name varchar(255),
NameImage varchar(255),
Description blob,
Keywords blob,
Thumbnail varchar(255),
Graphic varchar(255),
LargeGraphic varchar(255),
DisplayPrecedence int(11),
StillMovie varchar(255),
FiveMovie varchar(255),
ThreeMovie varchar(255),
Active char(1),
PRIMARY KEY (ID)
);

Script that got from other site as follows:

<?
/************************************************************/
/Code: PHP 3 /
/Author: Leon Atkinson <[e-mail]> /
/Creates two form fields based on data from a database /
/Writes javascript that update field 2 based on field 1 /
/************************************************************/

/ To simulate database connectivity, I\'ll fill some arrays /
$store_id = array(\"1\",\"3\",\"4\",\"5\",\"6\");
$store_state = array(\"California\",\"California\",\"California\",\"Nevada\",\"Utah\");
$store_city = array(\"Los Angeles\", \"San Francisco\", \"Walnut Creek\", \"Las Vegas\", \"Salt Lake City\");
$numStores = 5;
$distinct_states = array(\"California\",\"Nevada\",\"Utah\");

/ create the javascript function the updates the city list /
echo \"<SCRIPT Language=\\"JavaScript\\">\n\";

echo \"function UpdateCity()\n\";
echo \"{\n\";

/ clear the city selector /
echo \"\tvar City = document.choose_store.city.options.length;\n\";
echo \"\twhile(City > 0)\n\";
echo \"\t{\n\";
echo \"\t\tCity--;\n\";
echo \"\t\tdocument.choose_store.city.options[City].text = \'\';\n\";
echo \"\t\tdocument.choose_store.city.options[City].value = \'\';\n\";
echo \"\t}\n\n\";
echo \"\tdocument.choose_store.city.options[0].selected = true;\n\n\";

/ figure out which state is selected/
echo \"\tvar StateSelected = 0;\n\";
echo \"\twhile(document.choose_store.state.options[StateSelected].selected==false) StateSelected++;\n\n\";

$StoreState = \"\";
$CityCount = 0;

/ If this weren\'t a demo, I\'d run a query something like: /
/ select from store order by State /
/ But since this is a demo, I\'ll just read from an array */
$RowCount = 0;
while($RowCount < $numStores) {
$store_ID = $store_id[$RowCount];
$store_State = $store_state[$RowCount];
$store_City = $store_city[$RowCount];

if ($StoreState != $store_State) {
if ($StoreState != \"\") {
echo \"\t}\n\";
}

  echo \"\\tif(document.choose_store.state.options[StateSelected].value == \'$store_State\')\\n\";
  echo \"\\t{\\n\";

  echo \"\\t\\tdocument.choose_store.city.options[0].value = 0;\\n\";
  echo \"\\t\\tdocument.choose_store.city.options[0].text = \'Choose a Store Location\';\\n\\n\";

  $StoreState = $store_State;
  $CityCount=1;

}

echo \"\t\tdocument.choose_store.city.options[$CityCount].value = \'$store_ID\';\n\";
echo \"\t\tdocument.choose_store.city.options[$CityCount].text = \'$store_City\';\n\n\";
$CityCount++;
$RowCount++;
}

echo \"\t}\n\";

echo \"}\n\";

echo \"</SCRIPT>\n\n\";

echo \"<CENTER><FORM NAME=choose_store>\";

echo \"<SELECT NAME=state onChange=\\"UpdateCity();\\">\n\";

/ This is another place I\'d put a query: /
/ select distinct State from store order by State /
echo \"<OPTION VALUE=0>Choose a State\";
$RowCount = 0;
while ($RowCount < count($distinct_states)) {
echo \"<OPTION VALUE=\\"\";
echo $distinct_states[$RowCount];
echo \"\\">\";
echo $distinct_states[$RowCount];
echo \"\n\";
$RowCount++;
}

echo \"</SELECT>\n\";

/ Now we need to know how many cities are listed for the state with the most stores /
/ select count() as items from store group by State order by items desc */
$MaxItems = 3;
echo \"<SELECT NAME=city>\n\";
$RowCount = 0;
while ($RowCount <= $MaxItems) {
echo \"<OPTION VALUE=$RowCount>\";
echo \"Choose a Store Location\n\";
$RowCount++;
}

echo \"</SELECT><BR><BR>\n\";

echo \"</FORM></CENTER>\";

echo \"<SCRIPT Language=\\"JavaScript\\">UpdateCity();</SCRIPT>\n\";

?>