generate all combinations of select menus

[SeenGee]

Hi,

I am putting together a system for managing options for bespoking a computer. There are multiple option sets, each of which contains its individual options so for example there is an option set called memory that contains options such as 1GB / 2 GB and an option set for HDD which contains options like 250GB / 1TB etc

Each possible combination is stored in a database in a single table which holds the product id, the option set id and the option value id along with various other stuff. AS there are a maximum of 10 option sets there are fields type{$VAR}set_id and type{$VAR}val_id going from 1-10.

I have made a nice management system for this the client now wants to be able to click a button to generate all possible combinations for each product so (to use the example above) the product would be available in

option 1: 1GB memory / 250gb HDD
option 1: 1GB memory / 1TB
option 1: 2GB memory / 250gb HDD
option 1: 2GB memory / 1TB

I'm having real problems getting my head round this one, any ideas please?
I can post some code samples of what i've done before but this may just add to the confusion.

[tekky]

<?php
//given a setup like this...
$options = Array('option1' => Array('1','2','3'),
	    	 'option2' => Array('A','B','C'),
		 'option3' => Array('!','@','#'));
$i = 0;
foreach($options as $name=>$arr){
	foreach($arr as $k=>$v){
		$results[$i][$name][$k] = $v;
	}
	$i++;
}
?>

I think that would work...

[SeenGee]

thanks for that but i'm not too sure how the $results array should then be used for the individual inserts which i would need to be in a format like:

$sql = "INSERT INTO `options_table` SET `optgroup1` = 'option1',`optval1` = '1',`optgroup2` = 'option2',`optval2` = 'A'`optgroup3` = 'option3',`optval1` = '!'";
$sql = "INSERT INTO `options_table` SET `optgroup1` = 'option1',`optval1` = '1',`optgroup2` = 'option2',`optval2` = 'A'`optgroup3` = 'option3',`optval1` = '@'";
$sql = "INSERT INTO `options_table` SET `optgroup1` = 'option1',`optval1` = '1',`optgroup2` = 'option2',`optval2` = 'A'`optgroup3` = 'option3',`optval1` = '#'";

.. and so on.