ChronoForms Multiple Dropdown | Multiple Querys

Question

Hi you all,first off all i have to thank you for the wonderful job you're making. Chronoforms is really amazing.Well, i'm having a few problems coding some stuff that i need. I have a Website that provides learning courses which are inserted in a database. The desired behaviour is - i click on one item in the first drop down menu ( containing all my course's category's ), the second drop down is filled with information asked to the database depending on what item you clicked first, the same process for the 3rd drop down. It is important to state that all the 3 levels are not in the same database table, as you can see in the next presented code. Note: I have not implemented the 3rd drop down behaviour yet as it is identical to the 2nd.My code :--?--";
$options1 = array();
$options1[] = "--?--";
$options2 = array();
$options2[] = "--?--";
$db =& JFactory::getDBO();
$query = "
  SELECT `id`, `tipo`
    FROM `formacao`;
";
$db->setQuery($query);
$data = $db->loadObjectList();
foreach ( $data as $d ) {
  $options[] = "id}'>{$d->tipo}";
}
if($d->tipo=="Financiada")
{
	$query = "
	  SELECT `id`, `area_formacao`
	    FROM `ffinanciada`;
	";
	$db->setQuery($query);

$data1 = $db->loadObjectList();
	foreach ( $data1 as $d1 ) {
	  $options1[] = "id}'>{$d1->area_formacao}";
	}
}
elseif($d->tipo=="Não Financiada")
{
	$query = "
	  SELECT `id`, `area_formacao`
	    FROM `fnfinanciada`;
	";
	$db->setQuery($query);
	$data1 = $db->loadObjectList();
	foreach ( $data1 as $d1 ) {
	  $options1[] = "id}'>{$d1->area_formacao}";
	}
}
elseif($d->tipo=="Comparticipada a 75%")
{
	$query = "
	  SELECT `id`, `area_formacao`
	    FROM `comparticipada`;
	";
	$db->setQuery($query);
	$data1 = $db->loadObjectList();
	foreach ( $data1 as $d1 ) {
	  $options1[] = "id}'>{$d1->area_formacao}";
	}
}
elseif($d->tipo=="Empresas")
{
//TO DO
}
else
{
/TO DO	
}

?>

Actually, is my first time dealing with php.Best Regards,Diogo Ribeiro

Forums

ChronoForms Multiple Dropdown | Multiple Querys