[Resolved] nesting arrays of info from database using php

kender

ok, i started with a javascript problem, its resolution creates a php issue for me

heres what i need to do

i have a database, table looks like this

+-----------------------+
| ID | RACE   | CLASS   |
+----+--------+---------+
|  1 | Elf    | Hunter  |
|  2 | Dwarf  | Mage    |
|  3 | Elf    | Warrior |
|  4 | Human  | Druid   |
|  5 | Ogre   | Mage    |
|  6 | Dwarf  | Druid   |
|  7 | Elf    | Druid   |
|  8 | Human  | Hunter  |
|  9 | Human  | Mage    |
| 10 | Ogre   | Druid   |
| 11 | Dwarf  | Hunter  |
| 12 | Ogre   | Hunter  |
+-----------------------+

i need to pull all this data, and format it like so

/*************************************************
* this will actually fit into a javascript code  *
* this is the formatting i need, notice the      *
* comma (or lack of) after the ()                *
*************************************************/

class = new Array(
	new Array(						   // Dwarves
		new Array("Druid", "Druid"),     // comma
  		new Array("Hunter", "Hunter"), // comma
		new Array("Mage", "Mage")        // no comma
	),
// Duplicated to show the Option Value and the Option Choice
	new Array(						   // Elves
		new Array("Druid", "Druid"),
		new Array("Hunter", "Hunter"),
		new Array("Warrior", "Warrior")
	),
	new Array(						   // Humans
		new Array("Druid", "Druid"),
		new Array("Hunter", "Hunter"),
		new Array("Mage", "Mage")
	),
	new Array(						   // Ogres
		new Array("Druid", "Druid"),
		new Array("Hunter", "Hunter"),
		new Array("Mage", "Mage")
	)
);

As you can see, I need to sort each array alphabetically, and each nested array should be alphabetical too

i dont need the comments, that is just to show you where the info was pulled from

im sure it involves nested while loops, but not sure how to get it formatted properly, and with comma's where necessary, and missing where not

its probably simpeler than i am thinking, but who knows, i like to make my life difficult

make sence?

halojoy

If there is a logic in the way these names should be stored
besides alphabetic sorting,
then it could be done

I do not get the logic, behind creation and of these arrays
Maybe I am not clever enough 😕

kender

it will be used in this script

<html>
<HEAD>
	<title>-</title>

<SCRIPT LANGUAGE="JavaScript">
<!-- Begin

classes = new Array(  

    new Array( 
        new Array("Druid", "Druid"), 
          new Array("Hunter", "Hunter"), 
        new Array("Mage", "Mage") 
    ),  

    new Array( 
        new Array("Druid", "Druid"),  

        new Array("Hunter", "Hunter"),  

        new Array("Warrior", "Warrior")  

    ),  

    new Array( 
        new Array("Druid", "Druid"),  

        new Array("Hunter", "Hunter"),  

        new Array("Mage", "Mage")  

    ),  

    new Array( 
        new Array("Druid", "Druid"),  

        new Array("Hunter", "Hunter"),  

        new Array("Mage", "Mage")  

    )  

); 

function fillSelectFromArray(selectCtrl, itemArray, goodPrompt, badPrompt, defaultItem) {
	var i, j;
	var prompt;

// empty existing items
for (i = selectCtrl.options.length; i >= 0; i--) {
	selectCtrl.options[i] = null; 
}

prompt = (itemArray != null) ? goodPrompt : badPrompt;
	if (prompt == null) {
	j = 0;
	} else {
	selectCtrl.options[0] = new Option(prompt);
	j = 1;
	}
	if (itemArray != null) {

// add new items
for (i = 0; i < itemArray.length; i++) {
	selectCtrl.options[j] = new Option(itemArray[i][0]);
		if (itemArray[i][1] != null) {
			selectCtrl.options[j].value = itemArray[i][1]; 
		}
		j++;
	}

// select first item (prompt) for sub list
selectCtrl.options[0].selected = true;

   }
}

//  End -->
</script>

</HEAD>
<BODY>

<FORM NAME="main" action="multidrop.html">

<SELECT NAME="Race" onChange="fillSelectFromArray(this.form.Classes, ((this.selectedIndex == -1) ? null : classes[this.selectedIndex-1]));">
<OPTION VALUE="-1">Select Race</option>
<OPTION VALUE="Dwarf">Dwarf</option>
<OPTION VALUE="Elf">Elf</option>
<OPTION VALUE="Human">Human</option>
<OPTION VALUE="Ogre">Ogre</option>
</SELECT>

<BR />

<SELECT NAME="Classes">
<OPTION>Select Class</OPTION>
</SELECT>

<input type="submit" value="ok" />
</FORM>

</body>
</html>

leatherback

Hi kewnder,

how it will be used is clear. but plaese answer this question:

Originally posted by halojoy
If there is a logic in the way these names should be stored
besides alphabetic sorting,
then it could be done

I do not get the logic, behind creation and of these arrays

kender

the arrays will be placed into a javascript script...
then the script will create the dynamic multiple drop down boxes populated by the results of the arrays

if that is not what you mean, then please rephrase the question.. i am unsure what you are asking if that is not it

kender

this is what i have so far, and the reuslts

test script

<?
include("Subs.php");
global $settings;

$result = mysql_query("SELECT cat_a_val, title FROM `item_cat_b` ORDER BY cat_a_val, title ASC"); 
$classes = array(); 

while($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
{ 
    $classes[] = $row; 
} 
mysql_free_result($result); 
$class = array(); 

foreach($classes as $c) 
{ 
    $tmp = array(); 

foreach($classes as $a) 
{ 
    if($a['cat_a_val'] == $c['cat_a_val']) 
    { 
        $tmp[] = $a; 
    } 
} 
if(!empty($tmp)) 
{ 
    $class[] = $tmp; 
} 
} 
print_r($class);

?>

result

Array ( 
	[0] => Array ( 
		[0] => Array ( [cat_a_val] => Dwarf [title] => Druid ) 
		[1] => Array ( [cat_a_val] => Dwarf [title] => Priest ) 
	) 
	[1] => Array ( 
		[0] => Array ( [cat_a_val] => Dwarf [title] => Druid ) 
		[1] => Array ( [cat_a_val] => Dwarf [title] => Priest ) 
	) 
	[2] => Array ( 
		[0] => Array ( [cat_a_val] => Elf [title] => Fighter ) 
		[1] => Array ( [cat_a_val] => Elf [title] => Hunter ) 
	) 
	[3] => Array ( 
		[0] => Array ( [cat_a_val] => Elf [title] => Fighter ) 
		[1] => Array ( [cat_a_val] => Elf [title] => Hunter ) 
	) 
	[4] => Array ( 
		[0] => Array ( [cat_a_val] => Human [title] => Druid ) 
		[1] => Array ( [cat_a_val] => Human [title] => Fighter ) 
		[2] => Array ( [cat_a_val] => Human [title] => Mage ) 
	) 
	[5] => Array ( 
		[0] => Array ( [cat_a_val] => Human [title] => Druid ) 
		[1] => Array ( [cat_a_val] => Human [title] => Fighter ) 
		[2] => Array ( [cat_a_val] => Human [title] => Mage ) 
	) 
	[6] => Array ( 
		[0] => Array ( [cat_a_val] => Human [title] => Druid ) 
		[1] => Array ( [cat_a_val] => Human [title] => Fighter ) 
		[2] => Array ( [cat_a_val] => Human [title] => Mage ) 
	) 
)

as you can see, i am far away from getting it right, as it is only close to the results i need, it is also duplicating them.

kender

working code, thanks for the help!

$menudisp = 'classes = new Array(';

$query = mysql_query("SELECT title from item_cat_a ORDER by title ASC") or die(mysql_error());
$num_rows = mysql_num_rows($query);
$count = '0';
while ($row = mysql_fetch_assoc($query)){

$count = $count + '1';
$menudisp .= '
	new Array(';

$btitle = $row['title'];
$queryb = mysql_query("SELECT cat_a_val, title from item_cat_b WHERE cat_a_val = '$btitle' ORDER by title ASC") or die(mysql_error());
$num_rowsb = mysql_num_rows($queryb);
$countb = '0';
while ($rowb = mysql_fetch_assoc($queryb)){

$countb = $countb + '1';
if ($countb!= $num_rowsb) {
$menudisp .= '
	new Array("'.$rowb['title'].'", "'.$rowb['title'].'"),';
} else {
$menudisp .= '
	new Array("'.$rowb['title'].'", "'.$rowb['title'].'")';
}
}

if ($count!= $num_rows) {
$menudisp .= '
	),';
} else {
$menudisp .= '
	)';
}

}

$menudisp .= '
);';