help - dynamic selector with mysql

[admin]

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 <[email protected]> */
/*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=http://www.phpbuilder.com/board/archive/index.php/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\";

?>