Dynamic Dropdowns and MySQLi
I'm trying to use MySQLi to build a couple of Dynamic Dropdowns. I've done it numerous times before using MySQL but have hit a road block doing this using MySQLi. From what I understand (via a couple of posts on the forums) the best approach is to build it in MySQL and then convert the code to work with MySQLi. I got most of the way with that but there's a couple of bits of code that seem to be beyond my abilities, particularly the following bit of code.
Note that the system I'm building allows someone to select a club and then a team (U8, U9, U10 etc). Not all clubs have the same amount of teams, hence the need for a Dynamic Dropdown. I'm using Dreamweaver CC on a Mac with Data Bridge 2.1. I'm assuming the final version of Data Bridge 2 will have MySQLi based Dynamic Dropdowns?
-----
if ($row_teams) {
echo "<SC" . "RIPT>\n";
echo "var WAJA = new Array();\n";
$oldmainid = 0;
$newmainid = $teams->getColumnVal("teamClub");
if ($oldmainid == $newmainid) {
$oldmainid = "";
}
$n = 0;
while ($row_teams) {
if ($oldmainid != $newmainid) {
echo "WAJA[".$n."] = new Array();\n";
echo "WAJA[".$n."][0] = '".WA_DD_Replace($newmainid)."';\n";
$m = 1;
}
echo "WAJA[".$n."][".$m."] = new Array();\n";
echo "WAJA[".$n."][".$m."][0] = "."'".WA_DD_Replace($teams->getColumnVal("teamID"))."'".";\n";
echo "WAJA[".$n."][".$m."][1] = "."'".WA_DD_Replace($teams->getColumnVal("teamDivision"))."'".";\n";
$m++;
if ($oldmainid == 0) {
$oldmainid = $newmainid;
}
$oldmainid = $newmainid;
$row_teams = mysql_fetch_assoc($teams);
if ($row_teams) {
$newmainid = $teams->getColumnVal("teamClub");
}
if ($oldmainid != $newmainid) {
$n++;
}
}
echo "var teams_WAJA = WAJA;\n";
echo "WAJA = null;\n";
echo "</SC" . "RIPT>\n";
}