The Situation: I'm trying to create a pair of dynamic dropdown boxes where the options in the second box are dependent on the selection in the first box. I call the first box "categories" and the second, "subcategories". I want to store the categories and subcategories in a mysql table(s) so that a user can dynamically update them. Currently, I have a single table called categories, with columns: id, category, and subcategory.
The primary code for selecting the options for the second box is in javascript. This code makes use of the following datasets for storing the various categories and subcategories. If I can get php to generate this text, then the dependent boxes will work. datasets=new Array(); datasets[0]="Category1,subCategory1_1,subCategory1_2,subCategory1_3,subCateg ory1_4".split(","); datasets[1]="Category2,subCategory2_1,subCategory2_2,subCategory2_3".split(" ,"); datasets[2]="Category3,subCategory3_1, subCategory3_2, subCategory3_3,subCategory3_4,subCategory3_5".split(","); datasets[3]="Category4,subCategory4_1,subCategory4_2,subCategory4_3,subCateg ory4_4".split(","); datasets[4]="Category5,subCategory5_1,subCategory5_2,subCategory5_3,subCateg ory5_4,subCategory5_5,subCategory5_6".split(","); etc… The Problem: Using the following code I can get php to print the results, but only in a line-by-line, category/subcategory format. Of course, this is NOT what is needed. Each subcategory name should be on the same line as its associated category. <?php $dbConnect = mysql_connect("localhost", "root", "pwd"); mysql_select_db("new_kb",$dbConnect); $sql = "SELECT * from categories"; $result = mysql_query($sql); for ($count = 1; $row = mysql_fetch_row ($result); ++$count) { print "<br>datasets[$count]=\""; print "$row[1],"; print "$row[2]\""; } ?> datasets[0]="Category1,subCategory1_1 datasets[1]="Category1,subCategory1_2 datasets[2]="Category1,subCategory1_3 datasets[3]="Category1,subCategory1_4 datasets[4]="Category2,subCategory2_1 datasets[5]="Category2,subCategory2_2 etc… Can someone explain how to write the php code to output the category and subcategory names from the mysql table to match the javascript format above. Thanks in advance for any help or suggestions. Roger Lewis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php