• for 3 cascading selects
• for 2 cascading selects
• The newest JSON version. In this version, each element can have any number of sub elements defined in the JSON object like in an XML document.

MySQL/PHP example (not suitable for the JSON version of Cascading Selects)

There are 3 related MySQL tables with country, city and street data:

This PHP code will generate the output for cascading arrays:

mysql_connect(”127.0.0.1″,”root”,”");

mysql_select_db(”project1″);

$i=0;

echo “level0=new Array()\n”;

echo “level1=new Array()\n”;

echo “level2=new Array()\n”;



$q0=”select country_name, country_id from country”;

$result0=mysql_query($q0);

$i=0;

while ($rows0=mysql_fetch_array($result0)) {

$id0=$rows0["country_id"];

echo “level0[".$i."]=’”.$rows0["country_name"].”‘\n”;

$q1=”select city_name, city_id from city where country_id=”.$id0;

$result1=mysql_query($q1);

$j=0;

echo “level1[".$i."]=new Array()\n”;

echo “level2[".$i."]=new Array()\n”;

while ($rows1=mysql_fetch_array($result1)) {

$id1=$rows1["city_id"];

echo “level1[".$i."][".$j."]=’”.$rows1["city_name"].”‘\n”;

$q2=”select street_name, street_id from street where city_id=”.$id1;

$result2=mysql_query($q2);

$k=0;

echo “level2[".$i."][".$j."]=new Array()\n”;

while ($rows2=mysql_fetch_array($result2)) {

echo “level2[".$i."][".$j."][".$k."]=’”.$rows2["street_name"].”‘\n”;

$k++;

} ;$j++;

} ; $i++;

}

?>